Filter Expression Help

[Jmal22]

Could someone please tell me why excel giving me #Name when using this expression?

ActiveCell.Formula2 = "=Filter(EnabledwithPriority!A2:DE&RowCount),(EnabledwithPriority!V2:V&RowCount<>""""),"""")"

Excel sees RowCount in this expression as a word and not a row number for column DE.
RowCount is a dynamic number that is changing. I done this before in expressions like Range("A2:DE" & RowCount) but that doesn't work using the filter function.

 

[Peter_SSs]

@dreid1011
Are you aware that you can 'multi-quote' in the same post? Click "+ Quote" at the bottom of 2 or more posts or selected texts as shown below

Then under the reply window ..

Just wondering because of your two posts with quotes only a minute or so apart as they could have both gone in the same post.

 

[dreid1011]

@dreid1011
Are you aware that you can 'multi-quote' in the same post? Click "+ Quote" at the bottom of 2 or more posts or selected texts as shown below

View attachment 107613

View attachment 107614

Then under the reply window ..

View attachment 107615

Just wondering because of your two posts with quotes only a minute or so apart as they could have both gone in the same post.

Yes, I am aware... I didn't think to reply to both of you at once. I was replying to you, then decided to reply to Alex as well after the fact, and it was easier to just reply to him instead of quoting him, editing my reply to you, then adding the quote in. If there is an issue with the way I did it, I will try to remember to multi-quote in the future. I apologize for any inconvenience caused.

 

[Peter_SSs]

It isn't a particular problem, particularly as an occasional occurrence, but when you get multiple sequential posts (you had three) by one person it can stretch the thread out to more pages and make reading/navigation of the thread a bit more cumbersome.