Cells function error

[Brython]

Hi

I have created a macro (see below) to include empty rows based on a cell value in the 3rd column. This macro works fine as long as I begin my data in the cells A1.

However, when my range starts in a different column then A, the macro does not work. I tried to make adjustments in the "Cells" function (for example by entering a cellreference there but it doesn't work). Can anyone help me what I should enter in the Cells function if I want it to change to other columns? (what I tried is changing the "1" in the first Cells formula but it didn't work). Thanks in advance

Please Login or Register  to view this content.

[Pepe Le Mokko]

Tags added

[Brython]

Sorry, my bad. Is it ok how I did it now?

Towards topic of the discussion, anyone that can help le out? I assumed that in the second argument of the Cells function wi could entire either a column or a range but apparently this isn't working. However, with a number it works...