5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

Help with an Excel Macro please?

by vagabondette
4 replies
I have a macro set up in excel but the range is only set for one cell and I need to change it to the entire column, or at least a wide range of cells. Can anyone tell me how to do that or point me to a resource? Thanks!
#excel #macro
  • Profile picture of the author blackjack
    you need to edit Macro, Press ALT+F11 and find the module where the code is and then find exact range reference and change it.
    {{ DiscussionBoard.errors[1807314].message }}
  • Profile picture of the author vagabondette
    Yes, I know that, thanks. I don't know what to change it to. That's the problem. I've tried everything I can think of but I've never edited a macro before so I don't know what how to do the range. I've tried A2:A50 and A2, A50 and just the column letter and other combos I can't remember.
    {{ DiscussionBoard.errors[1807842].message }}
  • Profile picture of the author tryinhere
    i will pm my email and get it fixed in 2 seconds for you
    Signature
    | > Choosing to go off the grid for a while to focus on family, work and life in general. Have a great 2020 < |
    {{ DiscussionBoard.errors[1807851].message }}
    • Profile picture of the author vagabondette
      Originally Posted by tryinhere View Post

      i will pm my email and get it fixed in 2 seconds for you
      Email sent, thanks so much!
      {{ DiscussionBoard.errors[1807876].message }}

Trending Topics