Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a Range depending on variables
Hi
Can somebody help me? I have two expressions that seem similar to me. But one isn't working. ("rowstart" and "nrmess" are both integer variables with positive values; "rng" and "rng2" are both "dim as range") This works: Set rng = Measurement.Range(Cells(4070 + rowstart, 4), Cells(4120 + rowstart, 4)) This doesn't work: Set rng2 = Sheets("data").Range(Cells(410, nrmess * 3 + 12), Cells(415, nrmess * 3 + 12)) Can somebody tell me, what is the reason?? Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting several variables at the same time | Excel Programming | |||
Setting variables to Nothing | Excel Programming | |||
Setting print area depending on a cell value | Excel Programming | |||
Setting a boolean depending on who called the macro | Excel Programming | |||
Setting a print range using variables | Excel Programming |