Hi
I need to select next cell from Heading when filter is using. I have recorded the macro but it has been selected range only.
Macro
Selection.AutoFilter Field:=2, Criteria1:="="
Range("C3").Selectwhat is code for select next cell after heading instead of Range.
Thanks in advance.
Regards,
M.G.SEKAR
Firstly - please post in an appropriate forum - I'm guessing this is meant for the XL Forum rather than Access - let me know and I will move it.
Secondly - use Code Tags around your VBA... ie
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Please edit your post accordingly.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks