Select top left corner in vba

[simonhellstrom]

Hey

I have recently discover the power of Excel and like what you can do with it.

I have a code that only work if you are standing in the top left corner (A1) when you are running the code/ pressing the button. Please help me to change the code so i can have any cell selected when the code is executed, The code is:

Please Login or Register  to view this content.

What the code does is to input date depending on what the inputbox gives. If the monday is the 2013-08-12 it will be written in B3 and 2013-08-13 to 2013-08-16 is written in the cells C3 to F3.

Thanks in advance!

[blackworx]

Hi Simon, you just need to replace the first instance of "A1:E1" in your code with "B3:F3"

[simonhellstrom]

Thanks for the solution to my problem