| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy cells to variable number of rows
I need to copy a formula (that a macro has entered at W3 & X3) down to the
last row for that particuliar wk. I've figured out how to get the number of rows for that wk( in this case i=93, i will change for each wk) but can't figure out the syntax for the Range: Selection.Copy Range("W4: ? ").Select ActiveSheet.Paste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| Creating a macros to copy and paste cells | Excel Discussion (Misc queries) | |||
| copy exact values from RangeA to Range B which has extra rows | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
