thanx a lot..
On Fri, Oct 23, 2009 at 8:56 PM, aju chacko wrote:
> HI mahesh,
> The patch I mentioned is aivilable in following web site
> http://support.microsoft.com/kb/948944 .
> Please download and install this patch,If again problem persits you have to
> install off
good day excel gurus,
im always printing a template worksheet with values. I'm wondering how to
automate this process.
the template needs to print *N* number of times, *N*=number of rows with
data in another sheet. Also options to select row with data to print in
the template.
However, in the
Microsoft requires the parameter of the MInverse method of data type
Variant (http://msdn.microsoft.com/en-us/library/bb239421.aspx). Try
declaring CoArrInv as Variant (as in Dim CoArrInv(3,3) As Variant).
Hope this helped,
Rolf
On Oct 18, 10:36 pm, seryozha wrote:
> Hello all,
>
> I am atte
If I correctly understand your requirement this code should do:
Sub InsertRowsAfter8DigitRow()
Dim r As Range
Set r = ActiveSheet.UsedRange.Columns("B")
Dim rCell As Range
For Each rCell In r.Cells
If rCell.Row >= 3 Then
If rCell.Offset(-1).Value = "" And Is8Di
I can't figure a way to do this by way of conditional formating, but I
can offer some VBA code that would do the trick. Place the following
code into the a standard VBA module of your workbook:
Public Sub ColorTable()
Dim rRow As Range
For Each rRow In ActiveSheet.UsedRange.Rows
I
I opened an Excel 2003 spreadsheet written by a Japanese colleague and
edited/ran a macro. In the process I consulted the VBA Help and the
information appeared in Japanese.
Then I closed the worksheet and opened my Excel 2003 program (English)
again from scratch.
Now within Excel my VBA Help co
I think I can help you with item 1, but don't understand item 2.
Here's my suggestion for item 1. Let's assume you have a macro named
macro1 then the code for what you are trying to do would be:
Activate Workbook
macro1
End Sub
There were two problems with your code:
1) Spaces are not allowe
Hey all,
I'm a web developer who's exporting grids of data from webpages into
Excel and I'm trying to look under the hood to get some answers. My
question: sometimes when I export a grid some of the cells in a
numeric column will be "Number" and some will be "General." All the
cells seemingly con
Following Hernant's suggestion I would consider to encapsulate this
process in a totally stand-alone C# application which instantiates a
separate Excel session that wouldn't interfere with your regular Excel
session. I would have to see the current VBA code to see how easily
this could be created.
Hi Rahul:
you will need to provide a LOT more information than this if you want
anyone to assist you with this problem. The first thing I noticed when
I opened your workbook was that you password protected your macros.
That's not a great start, because it prevented me from trying to
understand wh
HI mahesh,
The patch I mentioned is aivilable in following web site
http://support.microsoft.com/kb/948944 .
Please download and install this patch,If again problem persits you have to
install office service pack 1 & 2
aju v chacko
On Fri, Oct 23, 2009 at 3:09 PM, Mahesh wrote:
Thanks Norman,
You are the only one who found a solution.
Have a good one.
Nour
2009/10/22 Norman May
> Try the attached workbook.
> It contains a user defined function from www.ozgrid.com
>
> Norman
>
> On Thu, Oct 22, 2009 at 3:17 AM, NOURREDINE BELHAJ <
> nourredine.bel...@gmail.com> wrote
Hi,
I guess I should have specified that I was asking for a way to do the
setting of the axis values by VBA, automatically for different files,
instead of manually setting the maximum and minimum values.
Thanks!
--~--~-~--~~~---~--~~
-
Hi
I forgot to put cell references before posting the file here..
I think you can look into the formula yourself and replace the constant
values like "A" with the corect cell references like $C$6..
2009/10/23
> Thanx for your HELP.
>
> But my query is when I enter “A” or “B” automatic dat
Hi friends,
>
> Can any body help me in this i want to insert rows between alternate rows
>
> for example
>
> Row No.
>
> sr. no.
>
> name
>
> 10
>
> 1
>
> sachin
>
> 11
>
> 2
>
> piyush
>
> 12
>
> 3
>
> amit
>
> 13
>
> 4
>
> pankaj
>
> 14
>
> 5
>
> hitendra
>
>
> I want it to be
>
> Row No.
>
> s
Hemant,
Thank you for the response. I don't want to save the worksheet with
all of the underlying code. There is a lot of code that becomes
unnecessary once the worksheet has been created and saved. The
original workbook acts as a switchboard for creating new and
searching, opening, and closing p
Hi friends,
Can any body help me in this i want to insert rows between alternate rows
for example
Row No.
sr. no.
name
10
1
sachin
11
2
piyush
12
3
amit
13
4
pankaj
14
5
hitendra
I want it to be
Row No.
sr. no.
name
10
1
sachin
11
12
2
piyush
13
14
3
ami
Hellow friends
Please guide me in writing the macro
1] Whenever i open a particular file --- it start with urn macro 1 store
inside this file
i have try the below mentioned macro - but it does not work out.
Activate Workbook
run macro 1
End Sub
2] The another macro -that do the following
whi
Hi Manoj,
Thanx for your suggestion,
But when i m clicking on all commands, its given my error.
Please help..
On Fri, Oct 23, 2009 at 2:13 PM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:
> Hi Mahesh,
>
> Please note the solution of your problem as follows..
>
> After appl
Hello.
Select axis, Format axis, set minimum to 1/1/10 and maximum to
4/30/10.
HTH
Daniel
On 22 oct, 20:03, Wataridori wrote:
> Hi all,
>
> I was wondering if there is a way to set the axis values of a scatter
> chart to the maximum and minimum values given in the source data. For
> example, wi
Hi Mahesh,
Please note the solution of your problem as follows..
After applying filter just select the desired data, which you want to copy,
& than click the option "Select visible Cells" and than copy and
paste.
*for option "Select visible Cells" go to office button and than c
Dear All,
In the attached file, I want to format cells (a4 to l14) in a manner
where row colour would be same as appearing in coloumn M. In other
words, in row number 5, I want cells from A to L to be fileld in Green
color, in row 6 in red color, etc.
Is it possible to do so using conditional fo
Thanx for your HELP.
But my query is when I enter "A" or "B" automatic data display,(looks
like Vlookup formula)
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com] On Behalf Of Hemant Hegde
Sent: Thursday, October 22, 2009 8:45 PM
To: excel-macros@googlegroups.com
Su
Wow!
Some great suggestions! I read through these on my way to the office
this morning and had hoped to be able to try some but I was swamped on
another project almost all day. I can't express enough how thankful I
am to have found an outlet for my curiosity. It seems like there is
always some
Hi Aju,
Thanx for ur suggestion, but i m copying the cells not column
And i m w8ing for the patch
Mahender Bisht
On Thu, Oct 22, 2009 at 8:42 PM, aju chacko wrote:
> HI Mahesh Bisht,
> Please try to keep the cursor in data area instead
> of column heading whil
Hi Mahesh,
Please note the solution of your problem as follows..
After applying filter just select the desired data, which you want to copy,
& than click the option "Select visible Cells" and than copy and
paste.
*for option "Select visible Cells" go to office button and than c
26 matches
Mail list logo
