Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Problem with Special Cells

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Problem with Special Cells

Subject: Problem with Special Cells
From: Thomas Maffucci via AppleScript-Users <email@hidden>
Date: Thu, 9 Apr 2020 17:37:35 -0400

I recently came upon a situation in a Excel Spreadsheet that required a lot of cleanup. I needed to delete a great many blank (empty) cells. I came upon this problem.

I have attached test sample of alternating cells in a column containing data & empty cells.

Running Excel Version 16.16.20

tell application "Microsoft Excel"

launch

activate

set Shtno to 1

set theRange to special cells (range "A1:A79" of worksheet Shtno) type cell type blanks -- this works fine

--set theRange to special cells (range "A1:A80" of worksheet Shtno) type cell type blanks -- this fails when resulting range exceeds 40 multi ranges

delete theRange

End Tell

Attachment: Sample2.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Any Ideas Please

Tom Maffucci

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

Prev by Date: Re: Excel insanity
Next by Date: Setting the priority for outgoing Mail
Previous by thread: Re: Excel insanity
Next by thread: Setting the priority for outgoing Mail
Index(es):
- Date
- Thread