Hello everyone. 

I have a Excel macro that seems to work perfect at home however at my work PC I get a run time error 13. When I look at the VBA it highlights an error with my:  rng/Value   ….

MY goal of this sheet is to enter a begin and end date, this will provide a series of 1 to 7 values based on those dates. Only the values would be shown and the others not applicable would be hidden, which this also applies to the tabs . 

I will also note, my old workstation worked flawlessly though that needed an update from our tech support. Now that I have transferred, I am worried if my employer wants to use this Excel sheet, the entire department will need an update. 

Any advice? Thank you in advance for your time and support. 

​Hello everyone.  I have a Excel macro that seems to work perfect at home however at my work PC I get a run time error 13. When I look at the VBA it highlights an error with my:  rng/Value   …. MY goal of this sheet is to enter a begin and end date, this will provide a series of 1 to 7 values based on those dates. Only the values would be shown and the others not applicable would be hidden, which this also applies to the tabs .  I will also note, my old workstation worked flawlessly though that needed an update from our tech support. Now that I have transferred, I am worried if my employer wants to use this Excel sheet, the entire department will need an update.  Any advice? Thank you in advance for your time and support.      Read More

​