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!

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

How can I get the number of activecell with VBA ?

Status
Not open for further replies.

envc77

Structural
Joined
Oct 13, 2007
Messages
10
Location
KR
I attemped to get the number like this "activecell.page"
but I couldn't.
And I'm wondering the number of activecell.


 
Your question seems a bit vague.
What is your host application? Excel?
What number? row number, column number, cell value, page number the cell appears on, etc.
 
OH I'm sorry. It is a excel problem.
 
In general you will get better Excel VBA answers in forum766, as this forum is for straight Visual Basic.

For this question you can use ActiveCell.Column and ActiveCell.Row

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting
Steam Engine enthusiasts
Steam Engine Prints
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top