Linking VBA to a cell

[JamesT1]

Hi

I have a spreadsheet which is emailed weekly. The VBA code will automatically insert my branch name and "Banked Hours Report" into the subject line of the email

This is to be used by other branches,,, is there a way for the VBA to be linked to a cell containing the branch name and insert this and the banked hours heading into the subject line

Thanks

[royUK]

What code are you using/ It shouldn't be difficult to amend it.

[MatrixMan]

Hi - try this:

Please Login or Register  to view this content.

[JamesT1]

Hi Roy

This is the code currently used

Please Login or Register  to view this content.

[royUK]

Try using this code

Please Login or Register  to view this content.

[JamesT1]

Matrixman,,,

thankyou for your help,,, used your and the current code mixed and figured it out,,,

[shg]

Matrixman,

In this declaration,

Please Login or Register  to view this content.

... strSubject and strTitle are declared as Variants. This declares them all as strings:

Please Login or Register  to view this content.

[MatrixMan]

... of course - you're quite right Thanks for pointing it out shg - my oversight.