Hi All,
Can anyone help us.
Regards,
Satvik
Sent from BlackBerry® on Airtel
-Original Message-
From: sunil bn
Sender: excel-macros@googlegroups.com
Date: Wed, 12 Oct 2011 16:38:29
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro's for Mricrosoftoutlook
Dear Sunil,
Please try below code...
First you add Microsoft Outlook Library..
Step: Press Alt+F11->Tools-Reference->check Microsoft Outlook 12.0 Object
Library..then run code...
hope it wil be help to u..
Sub mail_current_workbook()
Dim olApp As Outlook.Application
Dim olMail As Ma
In this case, Z will ALWAYS be (4) because:
Range("A1").select ' Selects Cell A1, which means that A1 is now the "Active
Cell"
Z=activecell.row+3 ' Activecell is A1, because you selected it immediately
before.
It looks like you just need to drop the Range("A1").Select
line and have the macro us
Hi,
how can i learn macros
On Mon, Dec 20, 2010 at 1:27 PM, vebhav jain wrote:
> Hi All,
>
> Whats wrong in this code..
> Dim Z as long
> Range("A1").select
> Z=activecell.row+3
> where i need to select the third row from the current row.
>
> Thanks,
> Vebhav Jain
>
> --
>
> --
pls let me know how can i learn macros creations.
On Mon, Dec 20, 2010 at 2:46 PM, Upendra Singh Sengar <
upendrasinghsen...@gmail.com> wrote:
> Hi Vebhav,
>
> Nothing is wrong in below code but if you want to select 3rd row from
> current row, you should add one line to below code:
> Row(Z).se
Hi Vebhav,
Nothing is wrong in below code but if you want to select 3rd row from
current row, you should add one line to below code:
Row(Z).select.
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
On 20 December 2010 13:27, vebhav jain wrote:
> Hi All,
>
