Dynamic Named Range

[jdmc45]

Hi,

I have a table that goes from cell C40 to G40 (5 columns) and then down to an unspecified number of rows downwards, depending on the data. How do I create a dynamic range in VBA referencing this area that I can then copy and paste into an email (I already have this code)?

Best,
James

 

[RoryA]

If it is an actual table, then it is already effectively a named range.