for that you need to open the personal workbook in order to run a macro
from any workbook... you need to have that workbook open
i have windows 7 installed and excel 2007... so the path for personal
workbook for me is the below..
C:\Users\Vivek\AppData\Roaming\Microsoft\Excel\XLSTART\
ki
Hi Everybody,
I have created a macro in personal macro workbook, and saved it, it worked
very good as per my expectation, but now
when I run again the macro, it did'nt work the message like "Personal Macro
workbook should be open".
Is there anybody to help me ?
REHAN BAIG
--~--~-~--~--
Hi Tomy,
I think the problem is that you have the macro 'Selecting' the range which is
xlveryhidden.
Such a range can't be seleceted, but XL doesn't have to select a cell to work
on it.
Try the following code lines instead of what you have.
Sub Move_Data()
'
' Move_Data Macro
' Macro reco
Hi Epi,
One way is to use the Union thingy
Union(Range(Cells(1, 1), Cells(2, 2)), Range(Cells(3, 3), Cells(4, 4))).Name =
"RangeName"
Regards - Dave
> Date: Wed, 26 Aug 2009 18:14:05 -0700
> Subject: $$Excel-Macros$$ Combine multiple ranges using R1C1
> From: epi_cen...@hotmail.com
> To: exc
Hi
You can use the union function
it takes as argument various ranges you want to combine...
eg..
Dim MyRange as Range
Set MyRange = union(Range("A1"),Range("A2"), ..)
hope this helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com
Simple and best
=CEILING(9235200.23,50)/1000
hope this helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Aug 26, 2009 at 12:50 AM, jsa-dk wrote:
>
> ROUNDUP(9235200,23*2;-6)/2000
>
>
> On Aug 25, 1:39 pm, NOURR
Hello group,
after spending hours on the web searching for an answer i resort to
you with my "noob"-question:
How do I combine separated ranges of a worksheet like
Range("A1:B2, C3:D4").Name = "RangeName"
using R1C1 references as in (pseudocode)
Range(Cells(1,1):Cells(2,2), Cells(3,3):Cells(4,4))
I have not been successful in move data from one sheet to another when
the destination sheet (sheet3 in this case) has been hidden using the
following:
Sheets ( “sheet3” ) . Visible = x1VeryHidden
When I unhide sheet3 the following Macro works fine.
Sub Move_Data()
'
' Move_Data Macro
' Macro
Hi Vinod,
Did you find my solution or not?
This is my seventh mail.
Regards
Sandeep
On Wed, Aug 26, 2009 at 9:50 AM, Prashant Bhawar
wrote:
>
>
> On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote:
>
>> Hello Team,
>>
>> How do i rank only positive numbers. Plz help me on formula.
>>
>> Example
Hi Nourredine BELHAJ
Try this formula
CEILING(F18,50)/1000
Regards
Sivakumar
On Aug 25, 4:39 pm, NOURREDINE BELHAJ
wrote:
> Hi All,
>
> Hope you are well.
>
> I would like to ROUNDUP the figure below
>
> 9,235,200.23 € to 9,500
>
> Can you please advise ?
> Thanks
> --
> Regards
>
> Nour
hi
i got the solution with out extra column
hope this helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Aug 26, 2009 at 4:37 PM, vinod rao wrote:
> This will help.Thank you
>
> can you put formula without using Fcolu
Hi Vinod,
If you need then see this too. It is with both with and without NA error.
Regards
Sandeep
- Original Message -
From: vinod rao
To: excel-macros@googlegroups.com
Sent: Wednesday, August 26, 2009 3:53 PM
Subject: $$Excel-Macros$$ Re: Need help on formula
Plz help!
Dear All,
Can some one snagged for me american wire gauge calculator,
table or formula in excel,
--
Regards,
Mudassar Ramzan
--~--~-~--~~~---~--~~
--
Some important link
rows 1157, 1158, 1159 and 1160 also contain positive values. 0.34 so
these would be considered 1
like wise 1162 to 1156 also contain 0.6 which are again positive hence count
to ranks 5-10..
i hope you understand what i want to convey
Thanks and Regards,
Vivek Agrawal
Skype ID - vi
Hi Vinod,
Find the attached solution. If it not fullfill your request then let me know.
Regards
Sandeep
- Original Message -
From: vinod rao
To: excel-macros@googlegroups.com
Sent: Wednesday, August 26, 2009 3:53 PM
Subject: $$Excel-Macros$$ Re: Need help on formula
Plz
Hi Vinod,
Find the attached solution. If it not fullfill your request then let me know.
Regards
Sandeep
- Original Message -
From: vinod rao
To: excel-macros@googlegroups.com
Sent: Wednesday, August 26, 2009 3:53 PM
Subject: $$Excel-Macros$$ Re: Need help on formula
Plz h
how come it becomes difficult to add a column and then hide that. this
will not change the visual alsoas the column would be hidden i feel
it would be difficult to get without using F...
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy
Hi,
Check the attached formula, and let me know if this is what u r looking for
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of vinod rao
Sent: 26 August 2009 PM 03:53
To: excel-macros@googlegroups.com
Subject: $$Excel-M
This will help.Thank you
can you put formula without using Fcolumn, I want to findout the data from E
only because my workshee is restricted to add one more line.? any suggestion
on this plz.
On Wed, Aug 26, 2009 at 4:07 PM, vivek agrawal wrote:
> Hope This Helps
>
>
> Thanks and Regards,
> Vivek
Hope This Helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Aug 26, 2009 at 3:47 PM, vinod rao wrote:
> Hello Vivek,
>
> I could not get the right answer. I need like
>
> Example
>
> Amount Rank
> 200
Vidyut...Thanks a ton...!!
Regarding the excel utilities..->I don't think you need any excel utilities
for that.. you just need to change the formula references. One more thing,
which you might want to do is to install both the Analysis Tool packs which
are available in Tools-> AddIns.
Best Regar
Plz help!
I am looking as mentioned in column G
Plz see attached file.
On Wed, Aug 26, 2009 at 3:47 PM, vinod rao wrote:
> Hello Vivek,
>
> I could not get the right answer. I need like
>
> Example
>
> Amount Rank
> 200 3
> 100 2
> -50NA
> 10
Hello Vivek,
I could not get the right answer. I need like
Example
Amount Rank
200 3
100 2
-50NA
10 1
-5 NA
3004
Can you plz get it done in the new excel file?. Thanks Advance my friend.
On Wed, Aug 26, 2009 at 1:09
Please see the attached file.
You'll have to do few adjustments to work it out
Joby
--- On Tue, 25/8/09, suresh k wrote:
From: suresh k
Subject: $$Excel-Macros$$ IF condition formula
To: "Excel group"
Date: Tuesday, 25 August, 2009, 5:53 PM
Can anyone provide me the formula for below q
Hi Jonell,
Thanks much appreciated.
it works fine.
Regards
Nour
2009/8/26 jonell
> On Aug 25, 9:39 pm, NOURREDINE BELHAJ
> wrote:
> > Hi All,
> >
> > Hope you are well.
> >
> > I would like to ROUNDUP the figure below
> >
> > 9,235,200.23 € to 9,500
> >
> > Can you please advise ?
> > Thank
Thanks so much
2009/8/25 jsa-dk
>
> ROUNDUP(9235200,23*2;-6)/2000
>
>
> On Aug 25, 1:39 pm, NOURREDINE BELHAJ
> wrote:
> > Hi All,
> >
> > Hope you are well.
> >
> > I would like to ROUNDUP the figure below
> >
> > 9,235,200.23 € to 9,500
> >
> > Can you please advise ?
> > Thanks
> > --
> > Re
The third argument of the RANK function specifies the ranking order
Blank or "0" means ascending order
any other positive number or "1" means the other way round
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Aug 26
Thank you Very much.
Can we have in reverse order, I mean low to high.?
Advance thanks to all members.
Example
Amount Rank
200 4
1002
-50NA
10 1
-5 NA
300 4
On Wed, Aug 26, 2009 at 9:48 AM, vivek agrawal wrote:
> Hi
>
>
28 matches
Mail list logo
