mubi_masti
New member
- Joined
- Oct 8, 2011
- Messages
- 14
- Reaction score
- 0
- Points
- 0
One of the member of this fourm has provided an excel sheet in which by clicking the button whole date in the sheet selected. Now
i want to develop a macro which define the name of that range and copy the range reference in B2 cell
for example , name range as "tblheadings" and copy reference in B2 as: Sheet!$A$1:$A$5
i want to develop a macro which define the name of that range and copy the range reference in B2 cell
for example , name range as "tblheadings" and copy reference in B2 as: Sheet!$A$1:$A$5