Thread: Copying and pasting values to the last available column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dennis Tucker Dennis Tucker is offline
external usenet poster
  
Posts: 140
Default Copying and pasting values to the last available column
sanjay,

Is the column EA, Eb, EC... and so on the last used column + 1??

Dennis

"sanju" wrote in message
...
I need to update daily stautus to the particular column of the
worksheet. Now these values are updated daily in column 22 of
worksheet.
For today , copy values of acolumn 22 to EA.
tomorrow, copy values of column 22 to EB
day after , copy values of column 22 to EC and so on

regards
sanjay



Reply With QuoteReply With Quote