How to find the last filled value cell address

Help Activities
1

I have to find the last filled value cell address
For example if the last filled row is A1 the output should be A1

2

Hi @sruthesanju

Try looking at this post. The alternative is to open Excel and property visible checked.
Send HotKey

  1. Ctrl+End
  2. Ctrl+Down Arrow
  3. Ctrl+Right Arrow
3

Hi @sruthesanju

If we know the last index of the we can get it by using ASCII Value.

Convert.ToChar(65).ToString+(rowIdx).ToString

Please refer to the xaml below.

Main.xaml (7.2 KB)

Regards

4

How to get last index of the row

5

Hi @sruthesanju

datatable.Rows.count

This will gives the count of the last index

Regards

6

For particular roe how to get last index

7

Hi @sruthesanju

check with the below thread !

Regards

8

You can also get this from VBA code.

Dim Last_Row As Long
Dim Last_Col As Long

'Find the last non-blank cell in column A
Last_Row = Cells(Rows.Count, 1).End(xlUp).Row

'Find the last non-blank cell in row 1
Last_Col = Cells(1, Columns.Count).End(xlToLeft).Column

MsgBox "Last Row: " & Last_Row & vbNewLine & _
        "Last Column: " & Columns(Last_Col).Address(False, False)
9

16299004326982405351531878159958
162990043269824053515318781599581920×891 269 KB

Getting the above mentioned issue

10

Hi @sruthesanju ,

Try below code.
GetLastRow.xaml (7.9 KB)

Make sure you have installed below package

image
image883×476 32.5 KB

11

Will I get output for particular row last filled cell address

12

1629904166846918250445165996919
16299041668469182504451659969191920×891 80.7 KB

Here in fifth row last filled column is D5 hoe to find that

13

Load the sheet into a datatable. The number of rows in the datatable is the last filled row number. Then loop through the columns in that row to find the number (column index) of the last filled column. Convert that number to a letter (ie 1=A, 2=B, 3=C) etc.

Just remember, row and column indexes are zero based. So a column index of 2, you add 1, and that gives you 3 (C).

14

This is what you are looking for, to get Address of last filled cell?

What the invoke code giving you ?

15

I get XFD506 As output

16

Any updates on above mentioned question

17

Is it possible for you to share the file or dummy of it as same code working for me on test file ?

18

period-WPS Office.xls (10.5 KB)
Here I have the see the last filled row of period

19

You want the highlighted last filled value, is it?

image
image743×326 8.36 KB

20

Yes it’s cell address