software

See one answer in microsoft.public.excel.programmingPlease don't post the same question in multiple newsgroups. At best, it
tends to fragment your answers. It also tends to waste the time of those
answering questions that have already been answered in another group.
For tips on using these groups effectively, see

cpearson.com/excel/newposte.htm

In article gt;,
quot;JaimeTimbrellquot; gt; wrote:

gt; Hello All,
gt;
gt; I am very new tomacros and VBA and I have a question relating to a copy
gt; problem.
gt;
gt; The problem I have is in automating the number of rows down with which I
gt; copy a range of cells.
gt;
gt; At present in the macro I have this bit:
gt;
gt; Range(quot;T5:AC5quot;).Select
gt; Application.CutCopyMode = False
gt; Selection.Copy
gt; Range(quot;T6:T1008quot;).Select
gt; ActiveSheet.Paste
gt;
gt; now rather than '1008' I want the 1008 bit to be a number that appears in
gt; cell T1 (the number is different from sheet to sheet).
gt;
gt; How do I do that? I have tried for quite a while to find the solution using
gt; a lot of excellent MVP websites, but alas the problem appears to in my
gt; interpretation of their help!
gt;
gt; Regards,
gt; Jaime.

Thanks for your help. Sorry I didnt realise that all the sites were linked
and that I was causing a problem.quot;JE McGimpseyquot; wrote:

gt; See one answer in microsoft.public.excel.programming
gt;
gt;
gt; Please don't post the same question in multiple newsgroups. At best, it
gt; tends to fragment your answers. It also tends to waste the time of those
gt; answering questions that have already been answered in another group.
gt; For tips on using these groups effectively, see
gt;
gt; cpearson.com/excel/newposte.htm
gt;
gt;
gt;
gt;
gt; In article gt;,
gt; quot;JaimeTimbrellquot; gt; wrote:
gt;
gt; gt; Hello All,
gt; gt;
gt; gt; I am very new tomacros and VBA and I have a question relating to a copy
gt; gt; problem.
gt; gt;
gt; gt; The problem I have is in automating the number of rows down with which I
gt; gt; copy a range of cells.
gt; gt;
gt; gt; At present in the macro I have this bit:
gt; gt;
gt; gt; Range(quot;T5:AC5quot;).Select
gt; gt; Application.CutCopyMode = False
gt; gt; Selection.Copy
gt; gt; Range(quot;T6:T1008quot;).Select
gt; gt; ActiveSheet.Paste
gt; gt;
gt; gt; now rather than '1008' I want the 1008 bit to be a number that appears in
gt; gt; cell T1 (the number is different from sheet to sheet).
gt; gt;
gt; gt; How do I do that? I have tried for quite a while to find the solution using
gt; gt; a lot of excellent MVP websites, but alas the problem appears to in my
gt; gt; interpretation of their help!
gt; gt;
gt; gt; Regards,
gt; gt; Jaime.
gt;