After a bunch of macro's have finished processing I need to create a macro to identify if there is a value in column d, if so number column E starting from 100 at row 1. continue down the page untill it gets 10 blanks in a row ?
Does that make sense ?
Hi, excel_joel,
Donīt know your data...Does that make sense ?
Macro will clear data in Column E and only work if there are values in Column D (if there are Formulas xlCellTypeConstants should be replaced with xlCellTypeFormulas):
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
you nailed it !@ thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks