VBA Code
 

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.

VBA Code
 

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

--
Steve

"Steved" wrote in message
...
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.

VBA Code
 

Hello AltaEgo

Thankyou

Steved

"AltaEgo" wrote:

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

--
Steve

"Steved" wrote in message
...
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.

VBA Code
 

My pleasure. Thank you for the feedback.

--
Steve

"Steved" wrote in message
...
Hello AltaEgo

Thankyou

Steved

"AltaEgo" wrote:

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

--
Steve

"Steved" wrote in message
...
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.