Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reference the Column Number

Status
Not open for further replies.
mtm789

mtm789

Technical User
Feb 19, 2003
5
MY
I need to know the active column number I am located in so i can reference it in the macro

Thanks Todd
 
Sort by date Sort by votes
Hi Todd

If the cursor = on a cell in the column you need use
Code: 
ActiveCell.Column

Cheers
Nikki
 
Upvote 0 Downvote
Bear in mind that this returns the column NUMBER as opposed to the column LETTER so you will need to use the CELLS syntax to reference it rather than the RANGE syntax Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
627
mintjulep
M
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
367
Andrzejek
Andrzejek
remeng
  • Locked
  • Helpful tip
Calculate Week Number - Week in Month - Holidays
Replies
0
Views
330
remeng
remeng
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
1K
morechocolate
morechocolate
huiettcm
  • Locked
  • Question
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
369
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top