Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

2016-01-25 Thread Kat
Hi Paul, Please see attached the fortest.xlsx file for your attention. Cheers On Tuesday, 26 January 2016 04:18:22 UTC+8, Paul Schreiner wrote: > > you've only sent the "Tested.xlsm" file > Can you please include the fortest.xlsx file? > Otherwise, I would need to GUESS what file looks like. >

Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

2016-01-25 Thread Paul Schreiner
you've only sent the "Tested.xlsm" fileCan you please include the fortest.xlsx file?Otherwise, I would need to GUESS what  file looks like.It LOOKS like you're comparing columns A-C in one workbook to range C-E in another. However:you have: Set varSheetA = wbkA.Worksheets("Sheet1")Set varSheetB =

Re: $$Excel-Macros$$ Unique Problem in unhanding sheet

2016-01-25 Thread Paul Schreiner
I'm not sure what you are expecting.When I open the file, my "Review" tab shows: The highlighted "Protect Workbook" icon indicates that it's protected.Double-clicking on it prompts for a password to unprotect. Whoever protected it evidently specifically locked out the ability to view the hidden

Re: $$Excel-Macros$$ Unique Problem in unhanding sheet

2016-01-25 Thread Secret Shot
Dear Paul, thanks for looking in to it. But I am not getting any option to unprotect it. if it is protected then I should get any option to protect it. but it is not. Neither worksheet showing protected, nor workbook giving me option to unprotect it. pls suggest., On Sat, Jan 23, 2016 at 2:15 AM

Re: $$Excel-Macros$$ Re: VBA Code for Create Name Range

2016-01-25 Thread amar takale
Dear Mandeep sir, Suprb.. Thank you all for your help. I greatly appreciated it Regards Amar On Mon, Jan 25, 2016 at 1:24 PM, Mandeep Baluja wrote: > Check this out !!! Regards, Mandeep baluja >> https://www.linkedin.com/messaging/thread/6086488646137958400 > > https://www.facebook.com

$$Excel-Macros$$ how to open workbook from outlook when vba userfom open?

2016-01-25 Thread Satendra kumar
Hi Noorain sir & All all experts, how to open workbook from outlook when vba userfom open? -- Thanks & Regards Satendra Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook