Creating changing print ranges

[JohnZ1156]

I have an Excel table.
I want to print from the ActiveCell (for now A6771) to column K and last row in table.

The ActiveCell will change from month to month, will not always be A6771.
Need to "highlight" or select from the ActiveCell to column K and the last row in table.
Set print area and print.

 

[JohnZ1156]

In that case change xlWhole to xlPart

OMG, Thank you, thank you, thank you !!!
It works great. I am soooo jealous that I cannot do what you can do.
It's like magic.

 

[Fluff]

Glad to help & thanks for the feedback.

 

[JohnZ1156]

Glad to help & thanks for the feedback.

Did I give you feedback? If not, I would give you 5 Stars.
I'm very new to this message board "thing".
I spend hours and hours googling, and watching YouTube videos just to get the smallest thing to work.
I only wish I knew what is is like to have your knowledge.
Thank you again !!!

 

[JohnZ1156]

I'm trying to find an Excel macro to confirm the current date in the last cell of column A
I found this, but when I tested it, it always returns "No Date", even though I have the current date in the last cell of the column.

Sub macro1()

With Sheet1.Range("A1")
If Not IsDate(.Value) Then
MsgBox "No date"
ElseIf .Value = Date Then
MsgBox "Date is today"
Else
MsgBox "Date is NOT today"
End If
End With

End Sub

 

[Fluff]

As this is a totally different question, you need to start a new thread. Thanks

 

[JohnZ1156]

Sory, I'm not sure exactly how to do that.

 

[Fluff]

Exactly the same as when you started this thread.