How to write VBA macro to read a manually updated cell G3 content e.g. B7:T60 and then select a range based on this + sort

[ricohflex]

I an unable to find a book or Youtube video to help me write a macro.

I have a large worksheet, which I update and add more rows of data each day.
I manually update the range of the most recently updated data that I wish to sort, into a cell G3 at the top above the data.

For example today I update new info and the range I wish to sort is B7:T60
Two days later I may update the content in the G3 cell to B7:T67
Fourdays later I may update the content in G3 cell to B7:T75

I want to write a VBA macro to read that cell G3 and the select the Range based on the content.
Then do a Sort (no header row) on column H (ascending) and column L (descending).

Thanks for any help.

 

[Fluff]

Will the range always start at B7?

 

[ricohflex]

Will the range always start at B7?

In my worksheet, yes. It can be a fixed start cell for me. Always B7.
The actual worksheet is big. Like B7:T3510.
It cut it down to T60 in the example.

 

[Fluff]

Ok, how about

Sub ricohflex()
   Range(Range("G3").Value).Sort Range("H7"), xlAscending, Range("L7"), , xlDescending, Header:=xlNo
End Sub

 

[ricohflex]

Thanks will try it out.

 

[ricohflex]

Ok, how about

Sub ricohflex()
   Range(Range("G3").Value).Sort Range("H7"), xlAscending, Range("L7"), , xlDescending, Header:=xlNo
End Sub

Yes, it works. Thanks.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[ricohflex]

You are brilliant. I read many Excel books and the authors never figured this out. Merry Christmas.

 

[Fluff]

You're welcome & thanks for the feedback.