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

range("e2").copy range("wherever")

--
Don Guillett
SalesAid Software

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


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