 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008Pulling out numeric number from Activecell.Address
I need to get the numeric value of Activecell.Address into a variable so that I can do calculations. Example: ActiveCell.Address = $F$426. I need to pull out 426 and place in a variable. How can this be accomplished? Thanks, Les Hi Les, Try: Dim i As Long i = ActiveCell.Row --- Regards. Norman >I need to get the numeric value of Activecell.Address into a variable so >that [quoted text clipped - 5 lines] > Thanks, > Les Hi Les, The 426 is the row number so you could use: myVar = ActiveCell.Row That would give you an integer value for the row number. > I need to get the numeric value of Activecell.Address into a variable so that > I can do calculations. Example: ActiveCell.Address = $F$426. I need to [quoted text clipped - 4 lines] > Thanks, > Les Thanks. Les > Hi Les, The 426 is the row number so you could use: > [quoted text clipped - 10 lines] > > Thanks, > > Les |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.