LinkBack URL
About LinkBacks
I am getting the following error using the code below:
Unable to get the match property of the worksheetfunction class.
Thanks.
Please Login or Register to view this content.
I am getting the following error using the code below:
Unable to get the match property of the worksheetfunction class.
Thanks
Please Login or Register to view this content.
It's probably because no match has been found.
If posting code please use code tags, see here.
Hi,
Just wondering why you are choosing to use VBA when an examination (admittedly not in depth) of your code might suggest that normal Excel functions and conditional formatting could do all you want.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
is the line that is highlighted and that name is in column Z, row 4. Thanks.Please Login or Register to view this content.
I am not using conditional formatting because there are multiple things (reformatting,calculations,change_events, etc...) that are being done by this VBA. Thanks.
I'd look at the workbook but doesn't have any code in it.
I attached a copy. Thanks
The address of the range rData.Rows(4) is annovar!$A$4:$F$4, which kind of like doesn't include column Z.
If you want to find a value in a row then use the whole row, eg Rows(4)
Also, not sure using With Application.WorksheetFunction is a good idea, in fact that's the first time I've seen it.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks