Forum Discussion

Bronze Contributor

Jul 06, 2018

Solved

replacing as variables in sort,subtotal macros

In the macro for Sorting (below), I wish to replace "C2:C" with a variable (mrng), I wonder what is the right DIM - as variant? string? also, In the macro for SubTotal (below), I wish to replace th...

Wyn Hopkins
Jul 06, 2018
I see it's in the previous routine, you therefore need to pass it along with the other variables to the SortSubtotal routine

Bronze Contributor

Jul 06, 2018

BTW

how do you put the codes inside a 'box' like the one you did for Sub Sort()

thanks

MVP

Jul 06, 2018

Did you change mrng to a string?

to enter code, click in the reply button and then there is a </> icon

Lorenzo Kim
Bronze Contributor
Jul 06, 2018
Mr. Hopkins
pardon me, I do not see in this Message box the </> icon ..

where could it be? sorry for being so noob...
you mean I have to click this icon then type the codes for it to be inside a box?
man thanks
- Wyn Hopkins
  MVP
  Jul 06, 2018
  Hi
  
  Click Reply
  
  Then
  
  </> and paste your code
  - Lorenzo Kim
    Bronze Contributor
    Jul 07, 2018
    Mr. Hopkins
    pls see below image, I think mine is a different heading or so?
    I don't see the icon...
    Thank you
- Wyn Hopkins
  MVP
  Jul 06, 2018
  Hi
  
  Click Reply
  
  Then
  
  </> and paste your code
Lorenzo Kim
Bronze Contributor
Jul 06, 2018
Mr. Hopkins
I changed the mrng to string and still error, below is the image for the error..
I'm sure msheet as variant is correct as I had used it in ClearSheets() ..
I think the culprit is mcol, I've tried integer, long but it isn't working- maybe the way it should be written beside GroupBy:=mcol??. or maybe mrng?
many thanks
- Wyn Hopkins
  MVP
  Jul 06, 2018
  Try preceding SortSubtotal with Call Module1.SortSubtotal( etc...)
  - Lorenzo Kim
    Bronze Contributor
    Jul 06, 2018
    Mr Hopkins
    see below image
    thanks

Resources