View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jaimetimbrell[_7_] jaimetimbrell[_7_] is offline
external usenet poster
 
Posts: 1
Default macro copy problem


Hello All,

Another problem I have is in automating the number of rows down wit
which I copy a range of cells.

At present in the macro I have this bit:

Range("T5:AC5").Select
Application.CutCopyMode = False
Selection.Copy
Range("T6:T1008").Select
ActiveSheet.Paste

now rather than '1008' I want the 1008 bit to be a number that appear
in cell T1 (the number is different from sheet to sheet).

How do I do that?

Regards,
Jaime

--
jaimetimbrel
-----------------------------------------------------------------------
jaimetimbrell's Profile: http://www.excelforum.com/member.php...fo&userid=2616
View this thread: http://www.excelforum.com/showthread.php?threadid=51160