Jump to content
Macro Express Forums
Cory

How To Get Cell Position In Excel

Recommended Posts

Can someone tell me how to get your cell position in Excel to use in the macro.

?

Share this post


Link to post
Share on other sites

Cory,

Its crude as anything but by mouse clicking in the name box that contains the cell # (excel 2003) it auto highlights the cell #.

A copy command and paste to clipboard appears to work, then read back to a string from the clipboard

 

<MMW2:76,104><LCLK><CLIPE><CLIPC><CLIPP><TVAR2:01:03:><TBOX4:T:1:CenterCenter000278000200:000:%T1%%T1%>

Share this post


Link to post
Share on other sites

Thanks for the suggestion. At the moment I'm just mouse clicking on the control that is the cell reference window to the left of the formula bar. Whatever cell you're in will be there. I just know there must be a hotkey to get to that field just like there is for the formula bar and font size, I just don't know what it is. Thanks again though.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...