(SOLVED) InputBox vba code to start in cell A1

[Stona]

Good day

Please help

I have this vba code when u click on the macro it asks for the day of the month (todays date) in the inputbox and then shows as a message

i want when the macro is run to the 1st day of the month and then it must start in cell A1 on the excel sheet and populate downwards.

Please Login or Register  to view this content.

[Crooza]

Hi.

is this what you want?

Please Login or Register  to view this content.

[Stona]

Hi thank you. its what i wanted. One last favour please before i marked this thread closed and add reputation.

i changed your code little bit. Im here to learn right so i must also do my part.

can u change the code so that there is no spaces in cells?

[Crooza]

No problem. try this then

Please Login or Register  to view this content.

[Stona]

its not working

this is the code i have. when it copies the values in cells, the weekends are left out but there are empty cells in between.

i want the empty cells Not to be there

Please Login or Register  to view this content.

[Stona]

i added this code

Please Login or Register  to view this content.

it is working now thanks