No the problem doesn't get old. Your code just help me tremendously! Thank you.:clap:
I just used it for a complex dynamic name range creation sub and in case someone else would use it, I gave you the credit for that part of the code.
Printable View
No the problem doesn't get old. Your code just help me tremendously! Thank you.:clap:
I just used it for a complex dynamic name range creation sub and in case someone else would use it, I gave you the credit for that part of the code.
MsgBox Split(ActiveCell.Address, "$")(1) works, since the assumption for address is xlA1
11-21-2005, 10:16 AM :)
Mr Benson of Schenectady comes to VBAX?