PC Review


Reply
Thread Tools Rate Thread

Copy range down

 
 
Fernando G,
Guest
Posts: n/a
 
      31st May 2007
I have a macro that filter my data considering numbers in column "F" with
>0, then place a formula in very cell from "O3:T3", and I need to copy this

range down to the last row with information.
I have used Macro record but it gives me the range taken and this can be
different every time.

Thanks



 
Reply With Quote
 
 
 
 
Bob Umlas
Guest
Posts: n/a
 
      31st May 2007
Range("O3:T" & Cells(Cells.Rows.Count,6).End(xlup).Row).FillDown
Bob Umlas
Excel MVP

"Fernando G," <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a macro that filter my data considering numbers in column "F" with
>>0, then place a formula in very cell from "O3:T3", and I need to copy this

> range down to the last row with information.
> I have used Macro record but it gives me the range taken and this can be
> different every time.
>
> Thanks
>
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Range and Assign a Defined Name to the Pasted Range sgltaylor Microsoft Excel Programming 3 5th Dec 2009 12:47 PM
Copy range from Sheet1 into empty range in Sheet2 Buddy Microsoft Excel Programming 1 19th Aug 2009 12:07 AM
RANGE EXCEL copy cell that meets criteria in a range confused Microsoft Excel Worksheet Functions 3 27th Mar 2008 01:41 PM
How do I edit a selected range then copy the range into an new sheet??? dwyborn Microsoft Excel Programming 2 16th Dec 2005 04:11 PM
Create/copy combo boxes in one range if condition is met in a different range LB Microsoft Excel Programming 4 30th Sep 2005 12:21 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:19 AM.