LinkBack URL
About LinkBacks
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?
Please Login or Register to view this content.
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?Please Login or Register to view this content.
You have the wrong type of quotes they should be like " not the slanted type.
Ulnarian,
Was Fluff right? I've gotta know.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
OMG...Originally Posted by Fluff13
Hah, you're a genius, 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. TryPlease Login or Register to view this content.
Yes, because the current region will include row 1, which then becomes the header. TryPlease Login or Register to view this content.
Awesome!!!! Thanks!!!!
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks