This is probably easy, but I am not strong in VBA. I want to set up an InputBox for the user to enter a range of cells. I want to automate a copy / paste / value function for columns (Jan - Dec) to replace array formulas with the actuals once calculated to stop our excel 2000 from zeroing these out at times.
What is the correct syntax? I have this and it's not working:
C = InputBox("Which range to copy paste value?", "", "C24:I134")
Range.Select = C
Any advice is greatly appreciated!!!