COPYING A FORMULA IN CELL

[guest]

When i copy a formula in varying length of report it copies it till the end if i highlight a column and paste the formula in it. for eg i am concatenating column a & b and the i copy =CONCATENATE($A1,$B1) then i highlight column d and cut and paste it then it copies till the end ie 65000+ rows. problem is at the time of set print it thinks that there are so many rows now how to get rid of this problem and i am using macro

 

[guest]

Hi Derek,
Thanks a lot that works great.
-Ajay

 

[guest]

One more question? It works when the coulumns have numeric values but when i change the values to Text and then try to concatenate rc(-2), and rc(-1) it does not work

 

[Derek]

Hi Ajay
I have rechecked it and tested it with your change and both text and numbers work perfectly on my maching. I am using Excel 2000 on Windows 98SE.
When you say it doesn't work, does it display anything at all, do you get a runtime error or what?
regards
Derek