| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ranges
I'm new to using ranges so any help you can provide is appreciated. Here is
the string of cells I'm looking to copy to another workbook, but only if the cells in col B are populated. This is not working, Set rng = .Range("B20:B57", "82", "B85", "B86").SpecialCells(xlConstants, xlNumbers) Set rng1 = Intersect(rng.EntireRow, .Columns(1)) Set rng2 = Intersect(rng.EntireRow, .Columns(2)) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ranges
??82??
-- Gary''s Student "JOUIOUI" wrote: I'm new to using ranges so any help you can provide is appreciated. Here is the string of cells I'm looking to copy to another workbook, but only if the cells in col B are populated. This is not working, Set rng = .Range("B20:B57", "82", "B85", "B86").SpecialCells(xlConstants, xlNumbers) Set rng1 = Intersect(rng.EntireRow, .Columns(1)) Set rng2 = Intersect(rng.EntireRow, .Columns(2)) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ranges
oops B82
"Gary''s Student" wrote: ??82?? -- Gary''s Student "JOUIOUI" wrote: I'm new to using ranges so any help you can provide is appreciated. Here is the string of cells I'm looking to copy to another workbook, but only if the cells in col B are populated. This is not working, Set rng = .Range("B20:B57", "82", "B85", "B86").SpecialCells(xlConstants, xlNumbers) Set rng1 = Intersect(rng.EntireRow, .Columns(1)) Set rng2 = Intersect(rng.EntireRow, .Columns(2)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
| union of named ranges based only on the names of those ranges | Excel Programming | |||
| Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
| Counting variable ranges and auto-summing variable ranges | Excel Programming | |||
| named ranges - changing ranges with month selected | Excel Programming | |||
Linear Mode
