Hi
One small clarification we normally use end xl up to find out the last used row
Example : Range("F"&Rows.count).end(xlup).row to find out the last used cell in column F
but if i use any formula in the column say from F1 to F120 and the formula results in only space from cell
F100 to F120,so here last data appears only in F99,but this macro line give the row number as 120
is there any way to sort it out
Narayanan
Try this. Make sure the formulas in column F return a null string "" instead of a space " "
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you dear,how this works can you tell a bit.
You're welcome.
The .Find method is a text search. It's looking for the first visible text in column F from the bottom up.
ok sir again thanks for your explanation and link
Narayanan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks