Change from number range to regular/alphabetical range

Posted on 2011-10-19
Last Modified: 2012-05-12
Cells(5, count).code

Open in new window


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)


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!

Question by:Shanan212
    LVL 33

    Accepted Solution

    Cells(5, count) is only one cell and it points to a cell in row 5 of column count.

    You can get it's address using it's address property Cells(5, count).Address.

    Have you considered changing the data type of the argument passed to the function?

    If it was Range then you could pass either Range("E2") and Cells(2, 5).

    Or you could just pass Cells(2,5).Address.
    LVL 12

    Assisted Solution

    You could do something like this I suppose.

    Call ExampleFunction(Chr(64 + Count) & "2")

    LVL 13

    Author Closing Comment

    Both answers are very helpful!

    Thank you both!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now