Hi - I'm new to this so....
I created a function to sort 2 columns in my excel file - col G (which is numbers) and then col A (which is text)...it works great EXPECT it is also sorting the Header column...and I cant figure out why...what am I missing?
sample of my code
thanks!
Please Login or Register to view this content.
Last edited by witpa; 10-18-2017 at 09:52 AM.
Hi witpa,
Could you first edit your post above and select your code and click on the "#" icon which will put your code in code tags and display correctly.
Then:
Read:
http://excel-ask.blogspot.com/2012/1...od-in-vba.html
notice the section on Headers.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Sorry, that suggestion did not work in a FUNCTION...
I need to modify the code I have, and not use a MACRO within the excel spreadsheet as this function will be called from a UFT script.
Hi witpa,
What is a "UFT script"?
Is your problem still active if you can't use Excel VBA like your example above? Do you still need some help with this question?
If "UFT" means UDF (user-defined function, a function invoked via formula), that's not going to work. A UDF can't operate on (i.e., make changes to) another workbook
Entia non sunt multiplicanda sine necessitate
Hi,
I believe the correct line would be
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
UFT is HP's Unified Functional Test, a software testing tool.
UFT uses excel worksheets - they are imported in and exported out of the tool...
When the line of
was replaced with what was suggested in the article:Please Login or Register to view this content.
I got a syntax error in the functionPlease Login or Register to view this content.
What's the point of creating another instance of Excel to do this, rather than opening the file in the current instance?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks