Hi,
I would like to fit this code:
Range("start!b14").Formula = "=sumif(data" & "!$D$2:$O$" & Lrow & ",""<0"")"
to work with relative columns (instead of the fix one here)
Tia
Nati
Formula with relative columns
- Natit1
- Thread is marked as Resolved.
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
-
-
Relative to what?
-
relative to the number of columns .
In the example the columns are "d" (this column is always the first, so it is fixed for me) to "o", which means from 4 to 15.
But sometimes I'll have the data till column "s" or to "z", and I want the formula to be flexible of course (I know the number of the the last column)
Hope it is clear know
Thx
-
I found the answer
-
Then share it in case it helps someone else with a similar problem.
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!