Hi Paul,
Thanks for giving me the clue by "DateDiff". Till ur reply i dont know
"DateDiff" method since im a leaner it helped to find the solution below is
my solution for my requirement.
Dim b As Variant
Dim d1 As Date
Dim d2 As Long
d1 = "01-jan-2007"
L1: b = ActiveCell.Value
Dear alok
In my knowledge Microsoft not provide any MCA certification by microsoft
Following is the list of certification...
(1)MCTS:- Microsoft Certified Technology Specialist (MCTS)
certifications enable professionals to target specific technologies
and to distinguish themselves by demonstratin
Hi,
I need help with conditional formatting.
I have a conditional formatting inserted on a sheet which requires a value
to be either Yes or No to be updated in the cells. What i want to do is to
pop up a message when a user saves the sheet without entering the values Yes
or No in the required cell
require guidance regarding MCA certification by microsoft. Specifically for
EXCEL ( 77-602).
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/excelda
HI Guys
Any updates on this !
On 1/28/10, maulik desai wrote:
>
> Hi,
>
> I want a macro which can help to compare two or more then two excel sheet
>
> By row wise
> or by column wise or
> complete sheet
>
> or should have options to select the mode like said in above lines
> or can more th
Hi Gurus,
I am looking for a macro sheet which can help me to create one database from
diff excel workbooks
Exp: I am having 5 workbooks (Mumbai,delhi,Pune,kolkatta, Surat)
Each workbook has two worksheets (sheet1 & sheet2)
All 5 workbooks are updated on a daily basis
Now what i want is that i
Hi,
can some one help me, I need a macro which will send selected data
from MS-Excel to Outlook. When macro is run pre decided cells should
export to outlook.
please help.
Thank You
Mayank
--
--
Some important lin
Good evening All,
I want to be an MIS analyst do i need to learn SAS programming.
or will it be ok to learn advance excel, vba and macros.
Please suggest.
Sunil
--
--
Some important links for excel users:
1. Follow
Hi,
I am good in excel. But i want to learn vba coding. please
provide any vba coding related books. Thanking you all.
Regards,
Naresh V
--
--
Some important links for excel users:
1. Follow us on TWITTER for t
Hello,
I have 2 lists of data in different worksheets of the same workbook
similar to below:
ProductCity
Apples London
Oranges Birmingham
Pears Manchester
I want to create 1 list (2 columns) in 1 worksheet that looks like:
Product
"Please provide VBA Code"...
for WHAT exactly?
In your question:
"deleted the complete rows": use: Rows("4:4").EntireRow.Delete
or Range("A4").EntireRow.Delete
or cells(4,1).EntireRow.Delete
"if the cell contains dates before 1/1/2007"
what cell?
any cell in the row?
the cell in column "a" ?
y
You're welcome.
Regards - Dave.
Date: Wed, 21 Apr 2010 11:45:50 +0300
Subject: Re: $$Excel-Macros$$ Urgent Help Required in a macro
From: chaudhry.zahid@gmail.com
To: excel-macros@googlegroups.com
Thanks a bundle Dave. This has expedited my work even more. :-)
(P.S) Can anyone refer me
Hi,
Please see attached excel for solution.
Regards,
Swapnil.
On Wed, Apr 21, 2010 at 1:57 PM, Sundarvelan N wrote:
> Hi Group Friends,
>
>
> Please help in this regard. I need to deleted the complete rows if the cell
> contains dates before 1/1/2007.
>
> Please provide VBA Code
>
> Thanks
>
Thanks a bundle Dave. This has expedited my work even more. :-)
(P.S) Can anyone refer me to a good course from where I can learn to write
macros...
On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack
wrote:
> Hi Zac,
> Can I suggest a simpler approach?
> Using the Ctrl key, select the 2 cel
Hi Group Friends,
Please help in this regard. I need to deleted the complete rows if the cell
contains dates before 1/1/2007.
Please provide VBA Code
Thanks
N.Sundarvelan
--
--
Some important links for excel users
Chk it,,
Multiplies all the components of the two arrays and then adds the products —
On Wed, Apr 21, 2010 at 10:10 AM, Jai wrote:
> Dear All, Can you tell me that what is the work of sum product.
>
> --
> Thanks For Mail.
>
> --
>
> -
Hi Jai,
Sum product formula will give you sum of product of two columns or arrays.
For ex:
Check the following table :
A B C
Product QtyPrice / unit
A 2 45
B 5 50
C 10 35
D
17 matches
Mail list logo