Hi there
Can anyone help me with this?
I want to write macto to locate a column with the text "Help" as the header and the select that whole column.
Forgive me if this seems too simple!
Hi there
Can anyone help me with this?
I want to write macto to locate a column with the text "Help" as the header and the select that whole column.
Forgive me if this seems too simple!
Hi,
Maybe
Assumes Row 1 has headers. Change as required
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
groovy - thanks
Glad it helped
VBA Noob
The code you sent selected the correct cell ("AK1") - I then added the following to insert a new column to the right of it and fill that column with formulas:
But do you know how to do this withoutthe hard coded reference to cell "AK2"Please Login or Register to view this content.
NIck
Try this macro
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
thank you very much for that - really helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks