Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have set ranges many times. Usually I set the range for more than one cell.
In this situation, I just want to use one cell. If this code works: Set count_range = Worksheets("Inventory").Range("L4") How come this code doesn't work? Set count_range = Worksheets("Inventory").Range(count_range.Offset(c ell_count)) Everything is defined properly, but I get an "Application-defined or object-defined error". Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem setting the used range for a column | Excel Discussion (Misc queries) | |||
Problem with setting value in validated range | Excel Programming | |||
Problem setting SeriesCollections source range | Charts and Charting in Excel | |||
setting range().hidden=True causes range error 1004 | Excel Programming | |||
Problem setting a range | Excel Programming |