I want to record a macro which includes the action of copying th
contents of cell E2. When I record, however, it writes in the VB cod
the particular data in E2 on that occasion. I want it to pick u
whatever the data is in E2 and this is not the same every time. I
there a way to copy "Contents of E2" rather than "Toronto" or whateve
happened to have been in E2 at the time of recording the macro

--
Message posted from http://www.ExcelForum.com