Link to home
Start Free TrialLog in
Avatar of Shanan212
Shanan212Flag for Canada

asked on

Change from number range to regular/alphabetical range

Cells(5, count).code

Open in new window


Hi,

I have the above being used in a function's loop. However, I have another function which uses 'alphabetical numer' (or not sure how to call this)

Eg:

If above points to A5:E2 (at a given point within loop)

I only want to extract the "E2" part to be sent to another function which is called by

Call ExampleFunction("E2")

Open in new window


I tried online search and searching here but I do not know what exactly to search.

Any help is appreciated!

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Shanan212

ASKER

Both answers are very helpful!

Thank you both!