excel01noob
Board Regular
- Joined
- Aug 5, 2019
- Messages
- 93
- Office Version
- 365
- 2016
Hello
I have a table with several columns.
The main one is column N where I want to take action as it is filled with "net amounts" but in text, plus not all the cells are filled, some have blanks, some others have zero also in text format.
I wanted to use column A "ref ID" to identify last row non-blank in that column which would define the last row in column "net amounts".
I want then to convert the numbers in text format into numbers with 2 decimals plus adding zeros in blank cells (what action should I take first here?)
I managed to do this
Dim LastRow as Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
Range("N" & LastRow).Select
but now how to select the column N going up until cell 2 (i am using headers) with the above criteria also included?
I have a table with several columns.
The main one is column N where I want to take action as it is filled with "net amounts" but in text, plus not all the cells are filled, some have blanks, some others have zero also in text format.
I wanted to use column A "ref ID" to identify last row non-blank in that column which would define the last row in column "net amounts".
I want then to convert the numbers in text format into numbers with 2 decimals plus adding zeros in blank cells (what action should I take first here?)
I managed to do this
Dim LastRow as Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
Range("N" & LastRow).Select
but now how to select the column N going up until cell 2 (i am using headers) with the above criteria also included?