Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dynamic range
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
dynamic range
This is the macro: Also, I just added rows of data into the "OPERAT"
workbook, and these new rows did not copy over into the Audit book workbook after I ran the macro again Workbooks.Open Filename:="U:\Courtney\Copy of OPERAT.xls", Notify:=False Sheets("INVESTMENT").Activate Range("auditbook").Select Application.CutCopyMode = False Selection.Copy Windows("Audit Book Template.xls").Activate Range("A3").Select ActiveSheet.Paste Windows("Copy of OPERAT.xls").Activate Application.CutCopyMode = False ActiveWorkbook.Close -- Allan "Luke M" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range | New Users to Excel | |||
Dynamic Range | Excel Worksheet Functions | |||
Dynamic Range | Setting up and Configuration of Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
help with dynamic range | Charts and Charting in Excel |