Member Login    |    Username:   Password:      Remember Me?:       |    Register

Excel VBA – Get / Display Current Cell Position

Excel Automation with VBA

Excel VBA – Get / Display Current Cell Position

Postby XCHANGE » Tue Sep 06, 2011 5:28 pm

Excel VBA – Get or Display Current Cell Position (Coordinates)?

To display the currently selected cell’s position in a msgBox:
Code: Select all
Please Register / Login to View Code

Excel VBA - To Get / Control the Currently Selected cell object?

As a related option: to get / control the currently selected cell as an object:
Code: Select all
Please Register / Login to View Code

Then, you could access the selected cell as an object and edit it’s characteristics as you would any other Excel range object.
ExcelHow.com - Automated Office (Excel, Word, Adobe, Quickbooks) Solutions for FREE!
User avatar
XCHANGE
Site Admin
 
Posts: 25
Joined: Wed Dec 22, 2010 5:44 am
Location: Clatskanie, Oregon, United States

Return to Automate Excel

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron