Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Bending the Skies
Lv 7
Bending the Skies asked in Computers & InternetProgramming & Design · 1 decade ago

How to Dim a variable as a Cell?

On Excel, I'm trying to code a macro that involves selecting a range of cells, in which both the upper limit and the lower limit cells in the range are variables. How would I go about programming this?

2 Answers

Relevance
  • garbo7441
    Lv 7
    1 decade ago
    Favorite Answer

    What defines the variables you wish to assign to your range of cells? Last Row? Last Column? Or...?

  • nobody
    1 decade ago

    Sub YourSubName(variableName as Range)

    End Sub

Still have questions? Get your answers by asking now.