http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><>&
ldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to
eldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just foll
.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><>&
the
earliest or refer any of your friends/colleagues for the same.
Rgds,
Ruapli Shanwade
iGate Patni Computer Systems Ltd.
--
Regards
Vasant
skype Id: vasantjob
http://facebook.com/vasantjob
--
--
Some important links
Hi Shree,
Apologies for the delay ..
Pls let me know what kind of HTML file would you like to convert ?
Could you pls send me those html files ?
btw
You can also use third party tools what Ankur has mentioned in his mail.
On Mon, Jul 11, 2011 at 5:11 PM, SHREE wrote:
> Thanks Vasant
lt;><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
gt; <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Regards
Vasant
s
ips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on faceboo
Hi Group,
Pls find a job opening for VBA in Gurgaon.
*Dear Vasant,
*Hi,
Trust you are doing good.
This is Harmeet here from DynPro India Pvt. Ltd.
About DynPro India Pvt. Ltd.:
Established in 1996, DynPro Inc was formed by a management team with
unrivalled experience in IT recruitment, E
:
> HI VASANT
> THNKS FOR UR EFFORTS
> EmpCode = ThisWorkbook.Worksheets("Sheet2").Cells(x, 1)..this code
> is not working
> U R GETTING IN RIGHT DIRECTION, NOW I NEED... THE STAFF NO OF NEXT EMPLOYEE
> GET CHANGED AND THE RESULT GET PASTED IN SHEET2M
com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><>
t;A2") = EmpCode
It = ThisWorkbook.Worksheets("gents report").Range("C2")
ThisWorkbook.Worksheets("Sheet2").Cells(x, 3) = It
Next x
End Sub
On Wed, Jul 6, 2011 at 1:20 PM, ankur wrote:
> HI VASANT
> PLZ FIND THE ATTACHED FILE
> this is sample file.
Hi Ankur,
Glad to help you. Pls send me your file...let me try :)
On Wed, Jul 6, 2011 at 12:34 PM, ankur wrote:
> hi vasant
> thnks for such nice code
> i have similar problem also...but i need some modification
> this code produce many workbook...cant it be possible to cre
Hi Ankur,
Glad to help you. Pls send me your file...let me try :)
On Wed, Jul 6, 2011 at 12:34 PM, ankur wrote:
> hi vasant
> thnks for such nice code
> i have similar problem also...but i need some modification
> this code produce many workbook...cant it be possible to cre
><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Regards
Vasant
skype Id: vasantjob
vasant...@gmai
to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
gspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><>
ups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> &l
-
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.c
ldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><>&l
To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow
and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><&g
blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><&g
;
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Ju
spot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><
Rng.Value = 2000 Or Rng.Value = 3000 Then
CalculateType = Rng.Value
Else
CalculateType = Rng.Value + 50
End If
End Function
On Tue, Jun 28, 2011 at 2:01 PM, Vasant wrote:
> try this.
>
> use this UDF for the type columns. Pass the Previous Type value into
> the function
>
>
---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutoria
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871
oin our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://excelda
TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tri
Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page
.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on faceboo
--
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blo
Application.EnableEvents = True
endif
End Sub
Sub Copy_April()
Flg=false
Sheets(1).Select
Range("A1:AG100").Select
Selection.Copy
sheets(13).select
Range("d10").Select
activecell.PasteSpecial :xl paste special values
flg=true
end sub
On Thu, Jun 23, 2011 at 2:12 PM, Rajesh K R
lledRange = cls
Else
Set DataFilledRange = Application.Union(DataFilledRange, cls)
End If
End If
End If
Next cls
With DataFilledRange
.Locked = True
.FormulaHidden = True
End With
WkSht.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
On Wed, Jun 22, 2011 at 7:28 PM, Ra
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
>
;<><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Regards
Vasant
--
-
wrote:
> Vasant,
>
>
>
> What are these codes doing?
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vasant
> *Sent:* Monday, June 20, 2011 12:37 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:*
t;><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Regards
Vasant
--
-
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><
m
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
-
_" & PrevMn & Trim(Str(Yr)) & ".xls"
FlPath = ThisWorkbook.Path & "\" & GetPrevMnthFile
If IsFileExists(FlPath) Then
ThisWorkbook.Worksheets("Memo").Range("F4").Formula =
"=SUM(prod!J2:J9)-SUM('" & ThisWorkbook.Path
other way round is writing a macro.
On Wed, Jun 1, 2011 at 7:00 PM, Skanda wrote:
> vasant everymonth we have to change the file name.i.e MAR_2011
>
> On Wed, Jun 1, 2011 at 4:58 AM, Vasant wrote:
>
>> Hi Skanda,
>>
>>
>> =SUM(prod!J2:J9)-SUM([DDD_Report_
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just f
//exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach ov
><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-worker
Can you be more precise what you want ?
Regards
Vasant
9880533187
On 8/20/10, ALAM wrote:
>
>
> Dear all,
>
> Solve my poblems
>
> Note:- I want to all details in excel sheet (like *NAME IN-TIME
> DATE
> ) *JUST CLICK OF *EMP ID*.
>
Yes, it is possible to do
Regards
Vasant
On 8/20/10, Chandra Gupt Kumar wrote:
>
> Dear All,
>
>
>
> My requirements are as follows;
>
>
>
> 1. Based on date of birth (Col D), mail to be sent on particular day
> to respective office for good wish
groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <
Congratulations Dave!
great help for all of us, keep contributing.
Regards
Vasant
On 8/4/10, NOORAIN ANSARI wrote:
>
> Thanks you very much *Dave*..
> God has given you a brilliant mind..and you always solve to group's problem
>
> Kindly Keep it in future..
>
>
ls(x + 3, 1)
Cntr = Cntr + 1
End If
Next x
End Sub*
Regards
Vasant
On Fri, Jul 30, 2010 at 7:56 PM, Ecovindaloo wrote:
> I need to create macro to reformat spreadsheet for importing into
> Access. As usual the spreadsheet is not formatted properly.
>
>
> Here is a piec
le All Macros
Hope this is clear
Regards
Vasant
On 7/30/10, Pooja S wrote:
> hi
>
> there is a problem in opening an excel file with macros...wht should be done
> to open the excel file with macros?
> pls rply soon..it i
Hi,
The Recd Date and Completion date is differs for each employee. So you
mean to say that date range has to be generated for each employee.
Could you suggest the format in which you want this to be done ?
Regard
Vasant
> Hi Vasant,
>
> This works great. Thanks for your help. Nee
gt;<><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscrib
eceive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Regards
Vasant
--
Here is your code.
Regards
Vasant
On Tue, Jul 27, 2010 at 6:31 PM, NOORAIN ANSARI wrote:
> Dear Experts..
>
> We want to transfer *Total Asset* column(F) in another sheet(Database) on
> daily basis in current date column through *Transfer in Database* Button.
> Please se
57 matches
Mail list logo
