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. F
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 wrote:
> Hi Dear all,
>
>
> Can any one send me setup of MS office 2010.
> It was download from net
Whoops, forgot the attachment.
On Mon, Mar 1, 2010 at 1:59 PM, Mark Kim 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
See attached for solution.
On Mon, Mar 1, 2010 at 6:18 AM, Umesh Matkar wrote:
> Pls suggest formula ..for below conditions
>
>
>
> From To Codes
>
> Jul-09Sep-09 JS0909
>
> Apr-09 Jun-09 AJ0909
>
> Oct-08 Mar-09 OM0809
>
> Apr-08 Sep-08 AS0808
>
> Oct-07 Mar-08 OM07
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
this range, I think I can use the
> following code to remove the blank rows..
>
> Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
>
> Could you revise the code???
>
> I really appreciate your help.
>
>
> On Fri, Feb 26, 2010 at 7:33 PM, Christopher Luka <
Dave & Abhishek,
Not so sure that's right. In Hanum's example, A points to C, A points to D,
and A points to E. It's a one-to-many relationship. Dave's example
contained a one-to-one relationship. Using Hanum's example, if I chose A in
the first dropdown, would the second dropdown be changed t
Check out the attached file. I think it will meet your requirements, and no
VBA required.
On Fri, Feb 26, 2010 at 11:25 PM, ankur wrote:
> hi hanum
> plz attach a sample file
> so it will more easy for us to help u
>
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Dif
My understanding of the way this works is as follows. When a piece of code
starts running, Excel compiles the current VBA code and runs from its
compiled state. When your code alters the VBA with the custom procedure,
it's stored there, but won't run until the current VBA stops executing & the
co
As a matter of advice, I'd use the offset/match combination even when you
can use a standard vlookup. In most cases, it's quite a bit faster than
VLOOKUP, *especially* when you have a large number of rows to process.
On Thu, Feb 25, 2010 at 8:45 PM, Manoj kumar wrote:
> Hi Anil,
>
> Please find
Take a look at the example attached. If you press Alt+F11 to view the code,
you'll see that I attached the code to the Worksheet_SelectionChange event.
This fires whenever someone selects a new cell on Sheet1 (in this case).
Additionally, I added two lines to prohibit the timestamp from being
ch
See attached for example.
On Thu, Feb 25, 2010 at 9:44 PM, Ayush wrote:
> Hi Markkim,
>
> Would you please send the sample file containing this data?
>
> Best regards,
> Ayush Jain
>
> On Feb 26, 6:18 am, Markkim wrote:
> > Hi
> > I have been trying to make these but have failed. ^ ^;;
> > I’d
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 wrote:
> hi umesh
>
> for learning vba , u can download books from our file section
>
> Have A Nice Time & Enjoy Life
>
See attached.
On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab 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 with
> data by
There's also a .RefersTo parameter that can be called.
On Wed, Feb 24, 2010 at 7:36 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Hi Group,
>
> In order to name ranges i use the following code:
>
> ActiveWorkbook.Names.Add Name:="Ctr1", RefersToR1C1:= _
> Strshtname & "R1
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 wrote:
> Hi,
>
> I have some source data in one sheet (Calculations) and formatted data
> in a second sheet (Output).
>
> In the Calculations
A couple of points:
1. IFERROR doesn't work on versions older than Excel 2007.
2. Second, if your concern is speeding up VLOOKUPS, switch to a combination
of INDEX & MATCH. It's much faster.
On Sat, Feb 20, 2010 at 8:07 AM, Ayush Jain wrote:
> Ayush Jain has sent you a link to a blog:
>
> Dear
If I'm not mistaken, what you're looking for is a *formula* that will
dynamically grab the value from Sheet1!A2 for Sheet2, Sheet1!A3 for Sheet3,
Sheet1!A4 for Sheet4, etc. If so, then the attached file should work for
you. Note that this formula VERY MUCH depends on the fact that the
worksheet n
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 wrote:
> I am doing analysis of 8 possib
19 matches
Mail list logo