Thread: Excel VBA, dynamic references
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Nattasiray Nattasiray is offline
external usenet poster
  
Posts: 3
Default Excel VBA, dynamic references
Dear

You must change the code to:
Range("AV" & [Av1]&":AV" & [Av1]).PasteSpecial xlPasteValues

[] Is Evaluate Method
Reply With QuoteReply With Quote