hello
i m using below code to filter my data
i want filter data with blanks cells
Sub FilterNamesOL() UnProtect_OL_BC Worksheets("OL BC").Range("OL_BC").AutoFilter _ Field:=11, Criteria1:=">=" & Worksheets("OL BC").Range("D6") _ , Operator:=xlAnd, Criteria2:="<=" & Worksheets("OL BC").Range("D6") Range("E9").Select Protect_OL_BC End Sub
thanx
Change your criteria to:
Criteria1:="="
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
MOD
NOT working
What does not working mean? What results are you getting? What were you expecting? Mind reading is not my specialty.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
i m using filter on range "C10:C500"
C10:C17 Has data
i filter the "AHSAAN G"
I want also filter blank row C18:C500
workbook attached
I apologize that I will not be able to help. Your file crashed my computer and I cannot open the file. Hopefully, someone else will have better success. Good Luck.
Ditto, Post#6.
Hey JOHN
what is Ditto, Post#6
Your file crashed my computer and I cannot open the file.Originally Posted by haroon2015
Hey JOHN
what is Ditto, Post#6
JOHN Sorry for that
but that file which one i upload is just about 567kb,,, its a sample of my workbook, and i m using 5mb version, never my pc crashed due to opening my file,,, then why yours pc is crashing can't understand
BTW
Will u plz check this thread
http://www.excelforum.com/excel-prog...ml#post3670323
thanx
Thread is closed due to crashing pc,,,,,
I apologize
to Mod alansidman And JOHN
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks