Thread: dynamic range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default dynamic range

If the macro directly copies the defined range;then blank lines also will be
copied.


"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