So, a bit of a simplistic question:
I have a worksheet that has a title row and then some populated rows. I simply want to find the last non-empty row in a specific column. Consider:
Code: Select all
n = pm.ActiveSheet.Columns(3).Rows.Count
Short of iterating through each row, examining each cell, is there any function/builtin that will return the last populated cell within a column? ...or even the first non-populated cell? I've tried hitting the manual... but it's sort of like working through seaweed... and I haven't been able to find a relevant example there.
I'm simply trying to build a script to apply a display attribute to an entire row based on a value in the row in a certain column. The 'sensible' thing to do would be to use Conditional Formatting... but I've literally spent days trying to get that to work when rows are inserted or appended to the existing rows of data and everything goes haywire.. hence this foray into BasicMaker. Ultimately, it'll be quicker to get the job done this way than to spend more time trying to get 'me of little brain' to come to grips with Conditional Formatting... and it'll be useful to know about anyway.
Although I've used VBA-like tools (SaxBasic, WinWrapBasic, etc) in a number of applications, I'm still trying to learn the extent of the Object Model here... and how it works.
I'm using PlanMaker 2021 (rev S1068.1105) and BasicMaker Professional 2021 (rev S1068.1105) , both 32-bit, under Windows 8.1 32-bit.
Thanks a heap.