I would like to data sort a sheet which has a header starting on Row 2. Whenever I try doing this, I get an error that A2 and F2 are non-defined variables.
Is there something obvious I am overlooking?
Sheet4.Range(“A2”).CurrentRegion.Sort Key1:=Sheet4.Range(“F2”), Order1:=xlAscending, Header:=xlYes
You have the wrong type of quotes they should be like " not the slanted type.
OMG...Originally Posted by Fluff13
Hah, you're a genius, thanks!
Ulnarian,
Was Fluff right? I've gotta know.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
You're welcome & thanks for the feedback
Ok, one more question.
When I run the above script, it actually data sorts my header.
That is, my header row (Row 2) ends up being data sorted to the bottom row. Does anyone know why this would happen?
UPDATE:Err, nevermind, something else is going on; it actually seems to be replacing my header value with the value of a subsquent row and then data sorting that. This seems weird because the newly-replaced header row still has the same formatting applied to it (i.e. all the data is in bold); its just that the header text has been replaced...
UPDATE 2: Ok, I fixed this, thanks all!
Last edited by Ulnarian; 03-27-2020 at 11:26 AM.
Do you have any data in row 1?
Yes; would that be an issue (it turns out my fix is no longer working...)
Yes, because the current region will include row 1, which then becomes the header. TrySheet4.Range("A2").CurrentRegion.Offset(1).Sort Key1:=Sheet4.Range("F2"), Order1:=xlAscending, Header:=xlYes
Yes, because the current region will include row 1, which then becomes the header. TrySheet4.Range("A2").CurrentRegion.Offset(1).Sort Key1:=Sheet4.Range("F2"), Order1:=xlAscending, Header:=xlYes
Awesome!!!! Thanks!!!!
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks