Assign Cell value to a variable

Hello all,

Long time-- no post. Hope all is well!

I need some assistance with a macro I'm working on. This should be pretty simple.

I need to take the value of cell C8 on the Home Tab of my active workbook and assign it to a variable (I believe an integer). The variable will be used as a date filter. (The input cell is a short date).

Here is what I have:

Please Login or Register  to view this content.

Thanks again!!

Declare filterdate as type Date or Long

Dim filterdate As Date

Otherwise, I'm not sure what assistance you need?

This counts the header row as well.

Please Login or Register  to view this content.