Destination:=Range -- want it to refer to the current cell

[lmcc007]

Cell A4 has a date.

I recorded a macro to go to the cell to the right, which is A4. Grab the handle and bring it down to cell A5 to give me the next date.

Is there a way to change =Range("A4:A5") to reference the current cell?

Selection.AutoFill Destination:=Range("A4:A5"), Type:=xlFillDefault

And, is there a way to excludes Sundays from all future dates. Something like if Sunday, go to next day.

 

[lmcc007]

Wow, it works. Thank you very much! I am doing a lot of stuff manually. I've tried watching VBA videos, but I am still lost--something doesn't click in my brain.

 

[Joe4]

Your are welcome!

I've tried watching VBA videos, but I am still lost--something doesn't click in my brain.

Give yourself some time, there is a lot to learn! But using the Macro Recorder like you have is a good start!
And reading threads of interest on this forum are helpful too.

As always, feel free to post any questions here!