Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross 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
Oct 13, 2007
10
KR
I attemped to get the number like this "activecell.page"
but I couldn't.
And I'm wondering the number of activecell.


 
Replies continue below

Recommended for you

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