Re: $$Excel-Macros$$ Loop issue

2013-04-28 Thread David Grugeon
Thanks, Ram So you are saying that it correctly does the line Rows("102:" & k).Select At that point you can look at the spreadsheet and see that the relevant rows have been selected. Then, when you run the next line Selection.Delete Shift:=xlUp It does not delete the selection. What does

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

2013-04-28 Thread Bill Q
Thanks David. On Saturday, April 27, 2013 5:18:45 PM UTC-4, David Grugeon wrote: > 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. >

$$Excel-Macros$$ macro recorders for excel on Mac OS10

2013-04-28 Thread r_luft
hi; wondering if anyone has any experience with using MSExcel on a Apple computer (OS10), together with any macro recorders so that the typical MS shortcut keys can be duplicated? I'm told that there are a few macro recorders available for the Mac (Jitbit, for one), and wondering if they work

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

2013-04-28 Thread Amit Desai (MERU)
Dear Paul, Thanks. But since the file is huge & having many columns I am not able to move entire sheet in transposed form...infact this sheet is fetching data from other sheets. I am trying to search something on line.. let me see if I can get. Best Regards, Amit Desai From: excel-macros@goog

Re: $$Excel-Macros$$ Loop issue

2013-04-28 Thread excel learner
hi Team, Can anyone please resolve my concern. Thanks. On Sun, Apr 28, 2013 at 12:06 PM, excel learner wrote: > 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