Cory Posted January 16, 2006 Report Share Posted January 16, 2006 Can someone tell me how to get your cell position in Excel to use in the macro. ? Quote Link to comment Share on other sites More sharing options...
Greg Posted January 17, 2006 Report Share Posted January 17, 2006 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%> Quote Link to comment Share on other sites More sharing options...
Cory Posted January 17, 2006 Author Report Share Posted January 17, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.