VBA Code

Steved · Jul 31, 2009

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 · Jul 31, 2009

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

Steved · Jul 31, 2009

Hello AltaEgo

Thankyou

Steved

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

AltaEgo · Jul 31, 2009

My pleasure. Thank you for the feedback.