PDA

View Full Version : Saving Cell Address by selecting It



mehyo27
02-09-2006, 05:18 AM
:hi: Good Day for All
Please I was trying to find the solution by my own with no success:banghead:

After running macro
I need it to ask for a cell
I will select it and the cell can be in another workbook or sheet
The cell address need to b saved for example in Worksheets("Data").Range("A1")
To be used after with another macro

Best regards

xld
02-09-2006, 06:10 AM
I would stick to the thread in OzGrid if I were you and stop wasting people's time by opening multiple threads for the same question.

johnske
02-09-2006, 02:09 PM
http://www.excelguru.ca/XLKBA/XLKBA05.htm

XLGibbs
02-09-2006, 04:43 PM
Please refer to the below for information on cross posting. If ample time has passed, post a continuing thread at one site and posting the link to that thread in all forums where a duplicate post has been made.

http://vbaexpress.com/forum/showthread.php?t=6905