Re: $$Excel-Macros$$ Need help in Vba Macro

2017-05-25 Thread KAUSHIK SAVLA
Hi Paul, The macro for this one is not working. Can you please share your file with macro. So i can compare with my file. I am getting error message the data cannot be pasted as shape and size are not same. Regards, Kaushik On Wednesday, May 24, 2017 at 4:29:56 PM UTC+5:30, Paul Schreiner wro

Re: $$Excel-Macros$$ Need help in Vba Macro

2017-05-24 Thread Paul Schreiner
What isn't working?What does your code look like? I put random numbers in 100,000 cells in  Book1.xlsbThen, in Book2, I put 100,000 cells with links to the corresponding cell in Book1. I then created a macro module with:Option ExplicitSub RemoveLinks()     Dim aLinks, inx     aLinks = ActiveWorkbo

Re: $$Excel-Macros$$ Need help in Vba Macro

2017-05-23 Thread KAUSHIK SAVLA
Hi Paul, The code is not working. Can you please provide full code starting with Sub...till End sub Regards, kaushik Savla On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner wrote: > If you also want to get rid of the "internal" links and formulas, you can > make use of the fact that, for a giv

Re: $$Excel-Macros$$ Need help in Vba Macro

2017-05-23 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS
On Tue, 5/23/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Need help in Vba Macro To: "excel-macros@googlegroups.com" Date: Tuesday, May 23, 2017, 9:53 PM That's very CPU intensive because it copies all cells to th

Re: $$Excel-Macros$$ Need help in Vba Macro

2017-05-23 Thread KAUSHIK SAVLA
Wow. This is what actually I require. I will test in my file. Thanks a lot. On May 24, 2017 00:43, "Paul Schreiner" wrote: > If you also want to get rid of the "internal" links and formulas, you can > make use of the fact that, for a given cell, the VALUE of the cell is what > is displayed, wh

Re: $$Excel-Macros$$ Need help in Vba Macro

2017-05-23 Thread Paul Schreiner
If you also want to get rid of the "internal" links and formulas, you can make use of the fact that, for a given cell, the VALUE of the cell is what is displayed, while the FORMULA of the cell is just that, the formula. For cells with a simple value, like "3", then the formula and value are nearl

Re: $$Excel-Macros$$ Need help in Vba Macro

2017-05-23 Thread KAUSHIK SAVLA
This is think will definitely help. Thanks. On May 24, 2017 00:23, "Paul Schreiner" wrote: > That's very CPU intensive because it copies all cells to the clipboard > and pastes them from clipboard. > which can be a HUGE number of cells for each sheet. > > If you simply want to break the externa

Re: $$Excel-Macros$$ Need help in Vba Macro

2017-05-23 Thread Paul Schreiner
That's very CPU intensive because it copies all cells to the clipboardand pastes them from clipboard.which can be a HUGE number of cells for each sheet. If you simply want to break the external links, you can use something like: alinks = ActiveWorkbook.LinkSources(xlExcelLinks)         If Not IsE

$$Excel-Macros$$ Need help in Vba Macro

2017-05-23 Thread KAUSHIK SAVLA
Hi Team, I am trying to do below in an excel. You can assume there are 60 worksheets minimum in a workbook. 1. In opened excel file. Which has links from several files 2. All cells of the workbook I am doing paste special values 3. Then to come at the first cell in all worksheets (i.e. Cell A1)

Re: $$Excel-Macros$$ Need Help in VBA

2016-10-11 Thread sonuraj1240
Thanks for Help On Tuesday, 11 October 2016 10:00:45 UTC+5:30, De Premor wrote: > > Try this one ! > > [dp] > > On 10/10/2016 19:46, sonur...@gmail.com wrote: > > Hi > > I need help for separate data through VBA. > > My Data is below type.. > sku Size > 10307963 XS,S,M,L > 103

Re: $$Excel-Macros$$ Need Help in VBA

2016-10-11 Thread sourav devrani
Use this Man Sub SplitTest() Dim VarArrayAs Variant Dim LngRAs Long Dim LngCAs Long Dim LngIndexAs Long Dim VaresultAs Variant LngIndex = 1 VarArray = Intersect(Sheet2.Range("A1").CurrentRegion, Sheet2.Range("A1").CurrentRegion.Offset(1))

Re: $$Excel-Macros$$ Need Help in VBA

2016-10-11 Thread Learner Excel
Hi Try below VBA code Option Base 1 Sub rr() For Each r In Range("b2:b" & Range("b9").End(xlUp).Row) x = Split(r, ",") For t = LBound(x) To UBound(x) Range("h9").End(xlUp).Offset(1).Value = Cells(r.Row, 1) Range("i9").End(xlUp).Offset(1).Value = x(t) Next Next End S

Re: $$Excel-Macros$$ Need Help in VBA

2016-10-10 Thread De Premor
Try this one ! [dp] On 10/10/2016 19:46, sonuraj1...@gmail.com wrote: Hi I need help for separate data through VBA. My Data is below type.. sku Size 10307963XS,S,M,L 10307973XS,S,L 10307978XS,S,M,L 10307979XS,S,L 10307980XS,S,XL 10307981XS,S,M,L 10307984XS,M,

$$Excel-Macros$$ Need Help in VBA

2016-10-10 Thread sonuraj1240
Hi I need help for separate data through VBA. My Data is below type.. sku Size 10307963 XS,S,M,L 10307973 XS,S,L 10307978 XS,S,M,L 10307979 XS,S,L 10307980 XS,S,XL 10307981 XS,S,M,L 10307984 XS,M,L Need this type data in result. skuSize 1030796

RE: $$Excel-Macros$$ Need help in VBA

2012-04-10 Thread Rajan_Verma
Hi, Can you share your Macro ? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of girish naik Sent: Apr/Tue/2012 10:28 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help in VBA Hi, I need to write a vba script wherein the

$$Excel-Macros$$ Need help in VBA

2012-04-10 Thread girish naik
Hi, I need to write a vba script wherein the macro will capture all the files present in windows registry(regedit).. i am able to capture the folder name present HK_LOCAL_MACHINE but not able to capture the files present in th folder. Please help me out with this. Thanks Girish -- FORUM RULES