| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range references in VB
I am trying to loop through rows and paste data on each row. I keep getting
an error code on this (even though it should be VERY simple)! j=1 Sheets("Array 1").Range("A75:ES75").Copy Sheets(Cbo_Product & "_BidformPage1").Select Range("A" & j).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False blah blah blah. I get the error on the Range("A" & j).select line. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making all references in a range absolute | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Arrays and range references in VBA | Excel Programming | |||
| Column and row references of range | Excel Programming | |||
| Bracketed Range References | Excel Programming | |||
Threaded Mode
