Hi.. i am creating a small macro for sorting my data in different sheets.
I am using "ActiveCell.Offset(1, 0).Select" to offset to select next row from the header line, but problem is, the function selects the hidden cell in Filtered Data which i dont want. I want it to Offset next row which is visible and not hidden.
Any Solution would be great.
Try this...
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.
Worked Perfectly.. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks