Thread: dynamic range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default dynamic range

Without seeing exactly how your code works, and assuming you're doing a
straightforward copy&paste, I would have to say yes, as that is how copy &
paste traditionally works. But again, it depends on your macro and how
exaclty you are "copying".
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Flipper" wrote:

I have a defined range in one workbookA. In workbookB, I have a macro that
copys the defined range from WorkbookA into Workbook B. If for some reason
blanks rows are inserted into the range, will those blank rows appear in
Workbook B when the macro executes?--
Allan