Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is what I want to do, have a macro to
Sheet 1 copy b17:017 I have this done so far as Worksheets("Sheet 1").Range("B17:O17").Copy That works Now how do I find the next blank row on Sheet 2 The range is between rows A12:A36 But I want to paste the values copied to the blank row to cells F??:S?? where ?? would be the found blank row number. And if now blank rows between A12:A36 report an error and stop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Macro - Copy/Paste Special to Next Blank Line | New Users to Excel | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Zero replaces blank field when paste special is used | Excel Worksheet Functions | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |