Selecting cells in the same row in various columns forClearingContents

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Thank you, Don

Got an immediate syntax error with your efforts.

I didn't mention that I'm using Excel 2003, VBA 2005, if that makes a
difference.

I've only been at this for a month with VBA.
Two books, 1000 pages each aren't much help for a beginner.

I have written code for 4 other procedures that work fine, a total of
about 3000 lines of code. 1 runs 2-3 seconds, 1 for 8 seconds, one for
15 seconds, 1 in a couple seconds. About a 2 day job manually.

My present one is nested loops which work, until I get to clearing
data where zero balance value is in the current row/cell address.
Sure seems like a it should be a simple procedure to me. This should
run about 5-8 seconds or so.

Of all the examples I've seen, nothing addresses this. Gosh, this is
a common procedure in cleaning obsolete data in an Inventory Control
file at EOM.

I have a rather complicated Master Excel file as it involves two
currencies with conversions, and all financial info, with two
inexperienced users. Can't use a common template.
This file has extra rows for data entry, so I'm trying to avoid a
procedure that performs a routine on empty rows, thus my use of data
count in each sheet. Do not want to delete empty rows.

Thanks a bunch. I'll keep on keepin' on.

Ed (e-mail address removed)
 
1. When replying pls stay in the ORIGINAL thread and reply to the post.
Archives....
2. No reason not to work. Send me a workbook if you like with snippets of
these emails and exactly what you want. Do NOT send to the list. Send to my
address below.
 
Back
Top