*Microsoft Office Specialist Certification*
[image: MOS Logo]
As a part of promotion for Excelytics Institute, we are offering MOS
(Microsoft Office Specialist) Excel Certification with Free Training at
discounted price, i.e. Rs. 2000/- (it costs you around Rs.3000/- in the
market). T
Dear Mandeep Sir,
Please help me on the same issue. Thse sheet is provided by you is not
giving correct output.
It gives NA# again. Kindly run macro and see the result in Cell C1 and C2.
Sheet is attached.
Thanks
Ashu Kenith
-- Forwarded message --
From: Ashu k
Date: Tue, Dec
Hey
try this:
Sub date_check()
Dim Date_Range As Range
Dim DateVal As Range
Dim DateAge As Long
Set Date_Range = Sheets("Sheet1").Range("A1:A500")
YearStartDate = DateSerial(2014, 1, 1)
For Each DateVal In Date_Range
DateAge = DateVal - YearStartDate
If DateAge > 100 Then
M
Try reversing the variables, not to result in a negative number:
Set Date_Range = Sheets("Sheet1").Range("A1:A500")
YearStartDate = DateSerial(2014, 1, 1)
For Each DateVal In Date_Range
DateAge = YearStartDate - DateVal
If DateAge > 100 Then
MsgBox DateVal.Ad
I'm trying to use a For loop to look through a list of dates in a worksheet
and flag cells whose dates are greater than 100 days.
Set Date_Range = Sheets("Sheet1").Range("A1:A500")
YearStartDate = DateSerial(2014, 1, 1)
For Each DateVal In Date_Range
DateAge = DateVal - YearStartDat
Yes, Vaibhav Joshi is the Best.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Thank you very much...Cheers!!
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Tue, Dec 30, 2014 at 12:26 PM, Vaibhav Joshi wrote:
> check this
>
> i m not getting any error..
>
> +
> *I did not
Cheers Buddy..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 5:34 PM, wrote:
> Joshi I admire your versatile capabilities
> Sent from my BlackBerry® wireless handheld from Glo Mobile.
> --
> *From: * Vaibhav Joshi
Joshi I admire your versatile capabilities
Sent from my BlackBerry® wireless handheld from Glo Mobile.
-Original Message-
From: Vaibhav Joshi
Sender: excel-macros@googlegroups.com
Date: Tue, 30 Dec 2014 17:28:28
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Su
Its difficult to ans without seeing actual URL, you can try this...
Sub Macro1()
Dim url As String
'enter your url below in quotes
url = "https://?=";
Application.ScreenUpdating = False
For i = 2 To 100 ' change start date and end date
With ActiveSheet.QueryTables.Add(Connection:=
Its difficult to ans without seeing actual URL, you can try this...
Sub Macro1()
Dim url As String
'enter your url below in quotes
url = "https://?=+";
Application.ScreenUpdating = False
For i = 2 To 100 ' change start date and end date
With ActiveSheet.QueryTables.Add(Connection:=
Data come from company intranet site based the given value(Excel columns
Value).
eg: website address:- https://?="*excel columns Value"*
On Tue, Dec 30, 2014 at 3:30 PM, Vaibhav Joshi wrote:
> Let us know site name & what part of data you want to download..
>
> +
> *I did n
Let us know site name & what part of data you want to download..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 3:26 PM, Rajeev Ranjan <06raj...@gmail.com> wrote:
> PLease if possible, share the code.
>
> On Sun, Dec 28, 2014 at 6:54 PM, Vaibha
PLease if possible, share the code.
On Sun, Dec 28, 2014 at 6:54 PM, Vaibhav Joshi wrote:
> check this...http://www.wiseowl.co.uk/blog/s393/scraping-websites-vba.htm
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Sun, Dec 28, 2014 at 12:43 PM, Rajeev Ranj
You can do so using macro..else you need to use dependent columns for data
validation list.
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 2:48 PM, Rakesh kumar
wrote:
>
> Hi,
> I need help on Dependent Data validation.
> and please try to sol
This solution will work for you !!! To create a dependent drop down list
provide some unique values as all persons having the same values .This can
be achieved without dependent drop down.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://ww
Hi,
I need help on Dependent Data validation.
and please try to solve it without adding any other column.
--
Thanks £ Regards
Rakesh Kumar
+91-9650303464 <#>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this fo
17 matches
Mail list logo
