May 22, 2003 #1 MadForIt Programmer Joined Aug 12, 2002 Messages 26 Location GB Hi Is it possible to return the address of the upper left cell in a range? i.e. Range("B14:F100" I just need it to return B14 Cheers.
Hi Is it possible to return the address of the upper left cell in a range? i.e. Range("B14:F100" I just need it to return B14 Cheers.
May 22, 2003 #2 nath Programmer Joined Dec 5, 2001 Messages 109 Location ES Hi, what you are looking for is Code: Range("B14:F100").Cells(1, 1).Address Nath Upvote 0 Downvote
May 22, 2003 Thread starter #3 MadForIt Programmer Joined Aug 12, 2002 Messages 26 Location GB Thanks Nath thats just what i need. Upvote 0 Downvote