Re: $$Excel-Macros$$ Loop issue

hi David, I tried step by step execution but still it is executing fine without any error but deletion part in first transaction tab is not done.. Thanks & Regards, Ram On Sun, Apr 28, 2013 at 12:04 PM, David Grugeon wrote: > You have highlighted 5 lines > > Try stepping through the code and f

Re: $$Excel-Macros$$ Loop issue

You have highlighted 5 lines Try stepping through the code and finding out which line does not work as required. Regards David Grugeon On 28 April 2013 16:25, wrote: > Hi Experts, > > i have come across an issue where in auto filter code is skipping over > without performing the required

$$Excel-Macros$$ Loop issue

Hi Experts, i have come across an issue where in auto filter code is skipping over without performing the required action and running next course of action. I Have highlighted the line where am getting error can any one correct me where am facing this issue. Macro is executing well but this p

Re: $$Excel-Macros$$ Copy/Paste Problem

I think you will Nero download the source code and go through it to extract the indicator (probably a CSS class) that turns a particular item green. It probably could be done in VBA but a big exercise. On Sunday, 28 April 2013, Bill Q wrote: > Hi, > > When copying and pasting from a particular s

Re: $$Excel-Macros$$ Create Sheets by given name.........

1/ Create one sheet Sub CreateSheet() Worksheets.Add End Sub 2/ Remove 1 sheet named "THANH", and create a new one sheet called "TRUNG" Sub CreateSheet() On Error Resume Next Application.DisplayAlerts = False Sheets("THANH").Delete On Error GoTo 0 Worksheets.Add

$$Excel-Macros$$ Copy/Paste Problem

Hi, When copying and pasting from a particular site in question - for whatever reason it will not copy the color. Is there anyway to keep the original color ? The link is *https://miseojeu.lotoquebec.com/en/results/complete-results*

Re: $$Excel-Macros$$ Create Sheets by given name.........

Hi Kuldeep, You can also try this. Sub CreateSheet() For Each rngCell In Selection ThisWorkbook.Worksheets.Add.Name = rngCell.Value Next rngCell End Sub Regards Priti verma On Fri, Apr 26, 2013 at 7:26 PM, Kuldeep Singh wrote: > Hi Experts, > > I want to create sheets by give

Re: $$Excel-Macros$$ Filter based on coulmns

So... you're saying copy/paste traspose isn't an option and you want a macro. do you know anything about macros? or are you wanting someone to write one for you? either way, if you want help with a macro, you'll have to provide WAY more information than you've given.   Paul

RE: $$Excel-Macros$$ Filter based on coulmns

You are right. Can you please suggest some macro for that? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 26 April 2013 17:17 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Filter based on co