Hello,
How can I uncheck "-" in Column Y via macro?
Hello,
How can I uncheck "-" in Column Y via macro?
I have looked at your file. I don't understand what you mean by thisPlease clarify what you want to do. What does Uncheck mean here?How can I uncheck "-" in Column Y via macro?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hello alan,
I mean filter. i just want to filter all except for "-"
Change your criteria to:
Please Login or Register to view this content.
Hi alan
I'm using the below code, and it gives me an error
Also, how can i filter only on the Column Y with values only?Please Login or Register to view this content.
Is it ??
Please Login or Register to view this content.
What is the error message? Which line is highlighted.
I suspect that it is in the Field:
If you are only filtering on the range Y8 then change Field:=1
Hi alan,
I'm using the below code:
I'm gettting an error 'Object required' on the highlighted line.Please Login or Register to view this content.
It's okay now. I've got it. Thanks a lot alan!
In this line of code
Remove the first period to look like thisPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks