Probably your real data has nothing to do with what you listed in post #1; I don't have a crystal ball.
Maybe changing the line of code:
Set repeat_cell_address
still isn't producing anything for me.
it runs now, but nothing happens
also, should i replace 'Year' with 'Month' on this line?...
fair enough. sorry...
rj1600 Yesterday, 08:06 PMHi, i'm currently create a excel data to calculate my earning and expense in a month. I need help to create formula to calculate average amount for upcoming...
smallEVILS Yesterday, 07:49 PM
Macro that concatenates two cells, references a Date and then copy pastes value into
can you upload the file you're working in?
rj1600 Today, 01:19 AMcan't figure out why it doesn't work on my side...