macro that will copy ONLY the value I have in cell I1, and then paste it to another cell based on the cell reference I declared in cell G13

[papajups]

Good day All,


Hope all is well.

Could you please help me have a macro that will copy ONLY the value I have in cell I1, and then paste it to another cell based on the cell reference I declared in cell G13.

For example:

I1 = “expired”
G13 = C38

With this, I would like to see the value ‘expired’ in cell C38 when I run the macro.

Also, if the cell declared in G13 is already pre-occupied with value, then please do not run the macro but throw an error message like “The provided cell number is pre-occupied. Please check and try it again”.


I sincerely hope that you can help me on this. Thank you in advance!


regards,
Papajups

 

[Eric W]

Re: macro that will throw an error message if the cell reference I declared in cell G13 is outside of range C25:V74

Probably the easiest way is to add a line to Joe's macro. After the "addy = " line, add this line:

    If Intersect(Range(addy), Range("C25:V74")) Is Nothing Then GoTo err_chk:

If you still want a DV rule, let me know. But it will probably be long and subject to error.