I understand how to create a named range using the offset function, but i
dont understand how to copy and paste a named range, can anyone help? thanks!

"confused" wrote:

Hiya,

I am copying an Excel worksheet to MS powerpoint using paste special option
so that when the Excel sheet is changed the MS powerpoiint also changes.

Is it possible to copy a variable length of rows? i only want to display in
powerpoint those rows with something in them, however the number of rows of
information in excel is dynamic

thanks for any help