$$Excel-Macros$$ Re: copying data from one workbook to other

Bold doesn't mean anything I said I highlighted the thing in bold which is require to mention Second thing used range can work on that wb.Sheets("sheet1").UsedRange.Copy Destination:=ThisWorkbook.Sheets(2).Range("A1") you can use activate a cell and then paste into it. On Tuesday, December 1

$$Excel-Macros$$ Re: copying data from one workbook to other

Mandeep, 1. how to bold any word in vba code window? wb.Sheets("sheet1").Range("B6:g6").Copy Destination:= Workbooks("nameanddate.xlsm").Sheets("sheet1").*Range("A1")* 2. in this code, we can not use "UsedRange" property ? 3. in this code , we can not tell to paste to activecell? (is it

$$Excel-Macros$$ Re: copying data from one workbook to other

thnx again :) On Tuesday, December 16, 2014 1:10:15 PM UTC+5:30, Mandeep Baluja wrote: > > wb.Sheets("sheet1").Range("B6:g6").Copy Destination:= > Workbooks("nameanddate.xlsm").Sheets("sheet1").*Range("A1")* > > on the same line no need to write paste and always specify where to > paste highligh

$$Excel-Macros$$ Re: copying data from one workbook to other

wb.Sheets("sheet1").Range("B6:g6").Copy Destination:= Workbooks("nameanddate.xlsm").Sheets("sheet1").*Range("A1")* on the same line no need to write paste and always specify where to paste highlighted in bold. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=

$$Excel-Macros$$ Re: copying data from one workbook to other

Hi, can we write copy past code in following way ? wb.Sheets("sheet2").UsedRange.Copy Workbooks("nameanddate.xlsm").Sheets("sheet1").Paste On Tuesday, December 16, 2014 12:26:41 PM UTC+5:30, ashak...@gmail.com wrote: > > > thank you so mu

$$Excel-Macros$$ Re: copying data from one workbook to other

thank you so much Mandeep :) On Tuesday, December 16, 2014 12:10:35 PM UTC+5:30, ashak...@gmail.com wrote: > > Hi all, > > Can anyone please help me with below code, why is it not working, what > mistake am i doing, > > Sub GetDataFromClosedWorkbook() > Dim wb As Workbook > Application.

$$Excel-Macros$$ Re: copying data from one workbook to other

Past is nothing it should be paste Sub GetDataFromClosedWorkbook() Dim wb As Workbook Application.ScreenUpdating = False Set wb = Workbooks.Open("C:\Users\pc\Desktop\inventory.xlsx", True, True) wb.Sheets("sheet2").UsedRange.Copy ActiveWorkbook.Activate * Sheets("shee