| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range syntax with variables
Can someone help me with the syntax for the following:
Dim Row As Integer Dim Col As Integer Range("A1:O45").Select Selection.Copy Row = 1 For x = 1 to 52 Row = Row + 48 Col = Row + 44 Range("A"Row:"O"Col).select ActiveSheet.Paste Next x I need the syntax for the Range statement. I want to select the range of rows for A49 through O93 A97 through O141 A145 through O189 .. .. etc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax for using variables in a cell formula to reference paths/fi | Excel Worksheet Functions | |||
| Syntax Help: Range variables (plucking data and pasting to 2nd sheet) | Excel Programming | |||
| VARIABLES IN ROWS - Help on The Right Syntax | Excel Programming | |||
| Range syntax | Excel Programming | |||
| Range.Select Using Variables - need syntax | Excel Discussion (Misc queries) | |||
Threaded Mode
