check the websites and videos at listed o n the below links
http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
On Tue, Jun 7, 2011 at 4:08 AM, Gagan Singh wrote:
> Hi,
>
> I've good knowledge of Advance
try this
http://akoul.blogspot.com/2011/02/merge-data-from-multiple-sheet-from.html
see if it helps
On Tue, Jun 7, 2011 at 2:37 AM, Greg wrote:
> Hi,
>
> I am trying to use a macro which copies multiple workbooks into a
> single workbook. However, something is going awry. The only thing it
> d
Hi,
I've good knowledge of Advance Excel. Now i want to learn of to do
programming through VB, make macro's in VB.Can some one give me a link of
the tutorial thru which i can learn the basics of VB.
Thanks a ton..
Gagan
--
---
Hi,
I am trying to use a macro which copies multiple workbooks into a
single workbook. However, something is going awry. The only thing it
does is create a blank Worksheet is created.
Can someone explain why this is happening? I copied the macro from the
following weblink:
http://excelribbon.tip
Hi
check
http://www.rondebruin.nl/mail/tips2.htm
On Mon, Jun 6, 2011 at 11:48 PM, Mahesh parab wrote:
> Hi
>
> which version of Excel you are using ?
> in 2007 its .SendUsingAccount property
> in 2003 its .SentOnBehalfOfName property
> can you send sample workbook.
>
>
> Thanks,
> Mahesh
>
>
Thanks for replydivya is content of the file..
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Mon, 6 Jun 2011 20:09:04
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$
I Think he want
Hi
which version of Excel you are using ?
in 2007 its .SendUsingAccount property
in 2003 its .SentOnBehalfOfName property
can you send sample workbook.
Thanks,
Mahesh
On Mon, Jun 6, 2011 at 9:47 PM, Simran Singh wrote:
> Hello experts,
>
> I am using email sending macro to send emails to the
May be, by hiding the rows that contains formula, before printing
A cell contaning formula can be detected by *HasFormula property*
Please check this code if it helps.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim MyRng As Range, r As Long, c As Integer
Set MyRng = ActiveSheet.U
Hello experts,
I am using email sending macro to send emails to the employees internally,
sometimes I have to send email from a particular DL for which i use below
mention line in the coding but it is not showing any DL name in from box.
.from=email address.
.to=employee email address
Kindly loo
Try :
Sub test()
Sheet1.PageSetup.PrintArea = "$A$3:$K$100"
Sheet1.PrintOut , , 1
End Sub
On Mon, Jun 6, 2011 at 3:01 PM, Daniel wrote:
> A guess :
>
> Sub RangePrint()
> Dim Rg As Range
> With Sheets("Sheet1")
>Set Rg = .Range(.[A3], .Cells(Rows.Count, "K").End(xlUp))
>Rg.PrintOut
> En
try this
Worksheets("sheet2").PrintOut Copies: 2
On Mon, Jun 6, 2011 at 4:58 PM, jmothilal wrote:
> Sir
>
> i want print 2 copies for my selected areas
>
> i am using print push button
>
> Worksheets("sheet2").PrintOut
>
> any one help
>
>
> Thanks with
>
> Mothilal.J
>
>
> --
> J.Mohilal
> Uni
I Think he want to search the content in file..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Monday, June 06, 2011 8:07 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
you want to search word divya is name of f
you want to search word divya is name of file or in content of file
On Mon, Jun 6, 2011 at 6:50 PM, wrote:
> Dear excel guru,
>
> I have a unique problem. Few days ago my hard disk was crashed. Now when I
> have recovered all the data,instead of file name assigned to those file,
> system has as
Sub test()
For i = 1 To Sheets.Count
Sheets(i).Select
' paste ur code here
Next i
End Sub
On Mon, Jun 6, 2011 at 2:12 PM, Kat wrote:
> Hi all,
>
> I have a large spreadsheet, ~200 sheets. For each of these, I wish to
> plot a series where the x values are D3:D103 and the y values are
> E3:
Dear excel guru,
I have a unique problem. Few days ago my hard disk was crashed. Now when I have
recovered all the data,instead of file name assigned to those file, system has
assigned file no.(i.e. system generated code to every file) I have 6 pdf
file to rename.
Is there any way to write
Sir
i want print 2 copies for my selected areas
i am using print push button
Worksheets("sheet2").PrintOut
any one help
Thanks with
Mothilal.J
--
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2
--
---
Hi all,
I have a large spreadsheet, ~200 sheets. For each of these, I wish to
plot a series where the x values are D3:D103 and the y values are
E3:E103, and the series name is the same as that of the sheet, all on
the same chart.
So far I have
ActiveChart.SeriesCollection.NewSeries
Acti
A guess :
Sub RangePrint()
Dim Rg As Range
With Sheets("Sheet1")
Set Rg = .Range(.[A3], .Cells(Rows.Count, "K").End(xlUp))
Rg.PrintOut
End With
End Sub
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bob
Envoyé :
Hello ,
I would require an excel cash book that would do the following things
1. Payments to party ( Debit )
2. Receipts from party ( Credit )
The operator should be able to enter only like the
Select Credit / Debit Entry
Enter Party Name :
Enter Cash Denomination :
Inward denomination -
Outwa
You are welcome Shekhar.
Thanks,
DILIPandey
On 6/6/11, Chandra Shekar wrote:
> Hi,
>
> Thank you very much, Its working fine. Thanks!
>
> On Mon, May 30, 2011 at 8:45 PM, Dilip Pandey wrote:
>
>> Hi Chandra Shekhar,
>>
>> The spreadsheet attached by you has been formulated as per your
>> requir
Good to know.
You are welcome.
Regards,
DILIPandey
On 6/6/11, ayoub Kakande wrote:
> Thank you sososo much,
> it has worked out just perfectly
> thanx again.
>
> On 5 June 2011 20:58, Dilip Pandey wrote:
>> Hi Ayoub,
>>
>> If you remove the named range and type the desired cell reference like
>
21 matches
Mail list logo
