Incognitus
09-02-2012, 12:40 PM
Hi,
I'm currently using a macro to copy and paste between two workbooks, one open and one not. The macro in itself works fine enough however there are a few adjustments that need to be made for it to be outstanding.
I tried several other macros, but using this method is the only one that doesn't give me "Object Errors", so I'm hoping it will be possible to continue using it.
Range("B19:I19").Copy Destination:=wb.Sheets("XC").Range("A" & Rows.Count).End(xlUp).Offset(1)
1.) How do I amend this to paste values?
2.) Currently, the range is one "row" within a small table on a worksheet with multiple small tables. Is it possible for it to instead be a selection of rows x big, but to only copy a variant number of rows between 0 - X rows dependent on how many entries are filled in on the B column?
Any help would be much appreciated.
I'm currently using a macro to copy and paste between two workbooks, one open and one not. The macro in itself works fine enough however there are a few adjustments that need to be made for it to be outstanding.
I tried several other macros, but using this method is the only one that doesn't give me "Object Errors", so I'm hoping it will be possible to continue using it.
Range("B19:I19").Copy Destination:=wb.Sheets("XC").Range("A" & Rows.Count).End(xlUp).Offset(1)
1.) How do I amend this to paste values?
2.) Currently, the range is one "row" within a small table on a worksheet with multiple small tables. Is it possible for it to instead be a selection of rows x big, but to only copy a variant number of rows between 0 - X rows dependent on how many entries are filled in on the B column?
Any help would be much appreciated.