VBA Code

[Steved]

Hello from Steved

Column G1 The Month Of
Column G2 ='Summary Report'!F3

in VBA please how do I have the above please
The reason is I screen dump a new file and then I have to Type G1 and G2
everytime.

Thankyou.

 

[AltaEgo]

Range("G1").Value = "The Month Of"
Range("G2").Formula = "='Summary Report'!F3"

 

[Steved]

Hello AltaEgo

Thankyou

Steved

Range("G1").Value = "The Month Of"
Range("G2").Formula = "='Summary Report'!F3"

 

[AltaEgo]

My pleasure. Thank you for the feedback.