Notifications
Clear all
BugOverflow
1
Posty
1
Users
0
Reactions
1,904
Widok
0
30/07/2015 9:19 pm
Topic starter
VBA top/left/right/bottom cell of selection?
1 Answer
0
30/07/2015 9:19 pm
Topic starter
With Selection MsgBox "1. Top left cell = " & .Cells(1).Address(0, 0) & vbLf & _ "2. Bottom left cell = " & .Cells(.Rows.Count, 1).Address(0, 0) & vbLf & _ "3. Top right cell = " & .Cells(1, .Columns.Count).Address(0, 0) & vbLf & _ "4. Bottom right cell = " & .Cells(.Cells.Count).Address(0, 0) End With