E
Erik Eddy
Is there any way that I can have the user enter a cell
value and that in turn will name the sheet and if that
happens will other macros that reference that sheet get
messed up and if so how could i also change that those
other macros to conform to the change on the fly. For
example :
c1 = value of what ever the name of sheet1 is at the time.
sheet1 = value of what ever the name of e1 is that is
entered by the user
b1 and c1 dont have to be on sheet1
value and that in turn will name the sheet and if that
happens will other macros that reference that sheet get
messed up and if so how could i also change that those
other macros to conform to the change on the fly. For
example :
c1 = value of what ever the name of sheet1 is at the time.
sheet1 = value of what ever the name of e1 is that is
entered by the user
b1 and c1 dont have to be on sheet1