I am trying to get the number of the last used row of a column also defined by a number.
When I use the usual way of doing this
This will give me the expected result when I step through the code but gives me an empty result when I run the code.' lrow = Cells(Rows.Count, StartPlace - 4).End(xlUp).Row
Rather than spend hours trying to sort that out I decided to try another way as I had a column nearby which is filled on every row
so I tried the following:
This is syntactically wrong and I would very much appreciate some help to put it rightlrow = WorksheetFunction.CountA(Columns(1, StartPlace - 6))
StartPlace is an integer. The number of a column
John
Bookmarks