Forum

VBA top/left/right/...
 
Notifications
Clear all

VBA top/left/right/bottom cell of selection?

1 Posty
1 Users
0 Reactions
1,839 Widok
0
Topic starter

VBA top/left/right/bottom cell of selection?

1 Answer
0
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

Odpowiedź

Author Name

Author Email

Your question *

 
Preview 0 Revisions Saved
Share: