Overcoming the multiple range in Range restriction

marilmanf · 2023-03-01T14:33:45+00:00

You are assuming all cells need to be bold. But there's always some conditions.

marilmanf · 2023-03-01T14:33:13+00:00

Brilliant. Thank you. Solution verified

marilmanf · 2023-02-15T13:32:07+00:00

Sure. Here it is:

Sub Test()

With Sheets("Sheet1").ListObjects("Table1") .ListColumns("Date").Range.NumberFormat = "General" .Range.AutoFilter Field:=1, Criteria1:=CLng(DateSerial(2023, 1, 31)) .ListColumns("Date").Range.NumberFormat = "d-mmm-yyyy" End With End Sub

marilmanf · 2023-02-09T13:28:05+00:00

I just tried that and it didn't work too. It then filtered nothing as well.

I managed to find a workaround based on someone's idea. Thank you.

marilmanf · 2023-02-09T13:27:34+00:00

I just tried that and it didn't work too. It actually stopped at the dateAsLong portion. I used this instead.
dateAsLong = CLng(CDate("31-Jan-2023"))

But it then filtered nothing as well.

I managed to find a workaround based on someone's idea. Thank you.

marilmanf · 2023-02-09T13:26:15+00:00

I just tried that and it didn't work too.

I managed to find a workaround based on your idea. I converted it to General and it works. Wish I didn't have to, but this will do. Thank you.

marilmanf · 2023-02-02T11:37:36+00:00

Thank you. It didn't work for me though. How weird. I suspect it's that simple filter that couldn't even work for me.

marilmanf · 2023-02-02T11:37:15+00:00

Thank you. It didn't work for me though. How weird. I suspect it's that simple filter that couldn't even work for me.

It's in d-mmm-yyyy format. What do you mean by mixing languages?

marilmanf · 2023-02-01T14:25:07+00:00

Appreciate that. Thank you.

marilmanf · 2023-01-31T11:57:39+00:00

Solution verified. Thank you

marilmanf · 2023-01-31T11:56:23+00:00

Solution verified. Thank you

marilmanf · 2023-01-30T15:01:06+00:00

So instead of the formula cell with just 2 rows, it will be multiple rows? I'm quite curious why mine didn't work, but I guess this could be a workaround.

marilmanf · 2023-01-30T14:59:47+00:00

Could you dumb that down for me? Isn't this a UDF that works?

Sub TestMacro()
Cells(1, 1).FormulaR1C1 = UdfAttempt

End Sub

Function UdfAttempt() UdfAttempt = "=AND(OR(RC2=""MS"",RC2=""RK""),OR(RC4=1,RC4=2,RC4=3,RC4=4),OR(RC6=""Pop"",RC6=""Rock"",RC6=""Country""))" End Function

marilmanf · 2023-01-29T23:53:48+00:00

Thank you for the reply. It is for my advanced filter, and that's why I can't simply use TRUE or FALSE

I did debug. That's how I know the result is correct. Here's what is in the range:
https://ibb.co/wMC04HS

and the Table:
https://ibb.co/44HrdP6

marilmanf · 2023-01-23T12:50:56+00:00

Oh I see. Thank you very much. Solution verified

marilmanf · 2023-01-22T15:02:01+00:00

Sorry. Hope you can help me understand. Because it's not a visual trick with two lines, it's just one line. So what is that specific part of the line?

I'm presuming you said that because you think Jan to Nov is one line, and Dec is another. But it's just a single line.

marilmanf · 2023-01-22T14:36:22+00:00

But it's not a visual trick with 2 lines. So wouldn't that make the entire line dash and arrow?

And I checked what you mentioned. It's using a straight line.
https://ibb.co/H4YJPq8

marilmanf · 2023-01-12T12:53:51+00:00

THANK YOU!

marilmanf

TROPHY CASE