No the problem doesn't get old. Your code just help me tremendously! Thank you.
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.
No the problem doesn't get old. Your code just help me tremendously! Thank you.
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
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Mr Benson of Schenectady comes to VBAX?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber