Need to set only the last row in a selection range in VBA

Asked Oct 01 '19 at 09:57

Active Oct 01 '19 at 10:05

Viewed 55 times

I need to format only the last row in a pre-selected area.

I have for example this code for selecting row number 2

Set PH = Range(Cells(Selection.Row + 1, Selection.Column), Cells(Selection.Row + 1, (Selection.Column + Selection.Columns.Count) - 1))

The remaining rows in the selection can be different from time to time, why I need a dynamic code to set only the last row in the selection.

Can anyone help with this?

edited Oct 01 '19 at 10:05

Damian

asked Oct 01 '19 at 09:57

Pernille

https://stackoverflow.com/questions/40650508/excel-vba-find-last-row-in-range – Siddharth Rout Oct 01 '19 at 10:02
3

Possible duplicate of [Excel VBA Find last row in range](https://stackoverflow.com/questions/40650508/excel-vba-find-last-row-in-range) – riskypenguin Oct 01 '19 at 10:02

0 Answers0