On Mar 18, 1:20*pm, "Dennis Tucker" wrote:
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- Hide quoted text -

- Show quoted text -

There are some blank column inbetween which I have kept hidden.
So EA onwards will be last visible blank column .
In fact I have all my calender mapped from column EA onwards .

regards
sanjay