Microsoft Office Forums - View Single Post - [Solved] Cell Range to Address Array

Thread: [Solved] Cell Range to Address Array

View Single Post

Old

10-20-2024, 11:05 PM

ImAhNoBoDy ImAhNoBoDy is offline

ImAhNoBoDy is offline

ImAhNoBoDy uses Windows 7 64bit

Windows 7 64bit ImAhNoBoDy uses Office 2007

ImAhNoBoDy uses Office 2007

Office 2007

Novice

The original poster

Join Date: Jan 2012

Posts: 17

ImAhNoBoDy is on a distinguished road

Default

Cell Range to Address Array

Is there a way to get an range and then get all the addresses of the range?

The range would be A1:E1, the output would be $A$1,$B$1,$C$1,$D$1,$E$1.

Reply With Quote