Re: $$Excel-Macros$$ VLOOKUP to check for multiple occurences of lookup value.

2010-03-05 Thread Christopher Luka
Hi Gaurav, While VBA is great (and I use it often), I recommend only using VBA when you absolutely need to. For starters, many users won't open an XLSM file for security reasons. Second, there are many more people who can maintain Excel formulas than there are those who can maintain VBA code.

Re: $$Excel-Macros$$ Request

2010-03-03 Thread Christopher Luka
I don't think any of us could legally send you a copy of Office 2010. You should contact the company you purchased it from and ask them to help you. On Wed, Mar 3, 2010 at 1:55 AM, sudhir kumar bluecore...@gmail.com wrote: Hi Dear all, Can any one send me setup of MS office 2010. It was

Re: $$Excel-Macros$$ Shell Object

2010-03-01 Thread Christopher Luka
The Shell command allows you to run other programs from Excel VBA. For example, you could type the following to open up Notepad in Windows: Shell Notepad.exe Make sense? Chris On Sun, Feb 28, 2010 at 10:45 AM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Hi Group, Some of the

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-03-01 Thread Christopher Luka
Whoops, forgot the attachment. On Mon, Mar 1, 2010 at 1:59 PM, Mark Kim mark@gmail.com wrote: thanks.. um.. where is the code? ^ ^ On Tue, Mar 2, 2010 at 6:01 AM, Christopher Luka christopher.l...@gmail.com wrote: OK, I modified the code to leave the six rows prior to the FBT

Re: $$Excel-Macros$$ Need help for macro- changing cell value

2010-02-26 Thread Christopher Luka
See attached. On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab mahes...@gmail.com wrote: Dear All I need macro for when i open workbook, A1 cell value, will display 1 to 4 numbers one by one, time interval should be 15sec. i want this to create animation effects in pie chart, cell A1 is link

Re: $$Excel-Macros$$ pls help - Vertical to Horizontal

2010-02-26 Thread Christopher Luka
You might also look up 'loan amortization' in online templates in Microsoft Office. The formulas are all built in so you can study them. On Thu, Feb 25, 2010 at 9:59 PM, ankur ankurpande...@gmail.com wrote: hi umesh for learning vba , u can download books from our file section Have A Nice

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-02-26 Thread Christopher Luka
See attached for example. On Thu, Feb 25, 2010 at 9:44 PM, Ayush jainayus...@gmail.com wrote: Hi Markkim, Would you please send the sample file containing this data? Best regards, Ayush Jain On Feb 26, 6:18 am, Markkim mark@gmail.com wrote: Hi I have been trying to make these but

Re: $$Excel-Macros$$ Cell referencing by formula

2010-02-20 Thread Christopher Luka
Here's an example with one way to do it. Let me know if the formula is too complex I'll walk you thru it. On Wed, Feb 17, 2010 at 10:49 AM, Maitre Bart maitreb...@maitrebart.netwrote: Hi, I have some source data in one sheet (Calculations) and formatted data in a second sheet (Output).

Re: $$Excel-Macros$$ Any way to use customer icons with conditional formatting?

2010-02-02 Thread Christopher Luka
One easy way to do it is to use the camera tool named ranges. The basic idea is contained in the link below. You'd just swap out the traffic lights for your own icons. http://www.exceluser.com/solutions/traffic.htm On Mon, Feb 1, 2010 at 12:50 PM, TD tim.deros...@gmail.com wrote: I am doing