Problem Setting Range
Yeah, I had issues with that already. I am only worrying about the rows this
time. Thanks!
"Mike H" wrote:
Hi
and when setting the offset ROW is assumed unless you incllude a comma to
indicate column
Set count_range = count_range.Offset(, cell_Count)
or you could include value for both row and column
Set count_range = count_range.Offset(10, cell_Count)
Mike
"baconcow" wrote:
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
|