*Yesit's working fine... This is what I wanted.*
*Thanks a lot ! Raja*
*
*
*Regards*
*Pravin Gunjal.
*
-- Forwarded message --
From: RAJA SEKAR apkra...@gmail.com
Date: Sat, Nov 3, 2012 at 10:03 PM
Subject: Re: $$Excel-Macros$$ Can cursor will go to cell D1 when we press
Hi,
I frequently have lists, each entry of the list is a one-sentence paragraph
ending in a full-stop (period), and is prefixed by a non-sequential number
or letter or combination, followed by a full-stop and then a tab. So, it
might look like this (tabs are shown as arrows, for clarity):
Hello sir
Can you please explain how to get completd years ,Months bet ween
todays date and pevius year date.example
01/04/1954
05/11/2012
please tell me the formula
thanq sir
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members
You can use the following formula
=YEAR(D4)-YEAR(D3) Years MONTH(D4)-MONTH(D3) Months
Aamir Shahzad
On Mon, Nov 5, 2012 at 4:51 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
You can use *DATEDIF()* formula.
Regards,
Kuldeep Singh
On Mon, Nov 5, 2012 at 5:11 PM, excel lerner
Hi team,
Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the
sample excel file, in Sheet 1 there is an attached Organization chart which I
am creating through VBA code., I want to fill each node of the chart
dynamically through VBA, but the problem is I am not able
You've asked for the FORMULA,
That implies that you don't want to use VBA, but wish to use Excel formulas.
Let's say that the date you're checking is in A2,
The simple answer is to subtract this year Year(Today())
From the year of the of the date in A2 Year(A2)
giving:
YEAR(TODAY())-YEAR(A2)
The
Sorry, this has nothing to do with deleting alternate sheets.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” -
I'm not quite sure what you mean by using find/replace.
I realize you want to replace 1a with 2, but perhaps there's more to it
than
that.
I'm not sure if you're looking for a VBA solution, or a Excel menu solution?
Is the data sorted? or are you intending to perform this replacement to ENABLE
Notice Forum Rule #3?
3) Don't post questions regarding breaking or bypassing any security measure.
WE don't have any way of knowing if you own the code or are simply trying break
into the code to determine some type of proprietary information (hacking)
If you are attempting to perform some
Have you noticed Forum Rule #1?
---
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
Dear team
i have data file in E drive i send mail to every 1 hr update
mail.summary sheet in body ,,mail send every update every 1 hr 24hrs,365
days any macro from this type of works in vba,,,
plz find attachment of sample file
--
*ThanksRegards
* *Veerendra.Vanam*
check the attachment see if it helps
On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam
veerendra.va...@gmail.comwrote:
Dear team
i have data file in E drive i send mail to every 1 hr
update mail.summary sheet in body ,,mail send every update every 1 hr
24hrs,365 days any macro
Right now its manual effort . You need to click on button every hour
Sent on my BlackBerry® from Vodafone
-Original Message-
From: veerendra vanam veerendra.va...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 5 Nov 2012 22:50:04
To: excel-macros@googlegroups.com
Reply-To:
Dear Sir,
i need automatic send with attachment how its possible any
one need help me,,,
On Mon, Nov 5, 2012 at 10:49 PM, koul.ash...@gmail.com wrote:
**
Right now its manual effort . You need to click on button every hour
Sent on my BlackBerry® from Vodafone
Congrats,
On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
Oct'12. He has posted 66 posts in last month and helped forum members
through his excel expertise.
I truly
You know, I've used DateDIFF in VBA, and I THOUGHT there used to be an Excel
equivalent.
but when I looked in Excel2010, I didn't find it in the function wizard.
Now it looks like it's THERE, but undocumented.
You can find it in ONLINE help, but not in the help file in Excel.
If you have the macro able to run by a button,
check the documentation for the OnTime function.
this should allow you to set it up to run at specific times.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the
dear sir i need send attachment also pls send vba code for attachment,,
On Mon, Nov 5, 2012 at 10:49 PM, koul.ash...@gmail.com wrote:
**
Right now its manual effort . You need to click on button every hour
Sent on my BlackBerry® from Vodafone
--
*From: *
thank you all for all your help...
Regards,
Vinay
On 4 November 2012 14:44, ashish koul koul.ash...@gmail.com wrote:
Sub loop_visible_cells_only()
Dim vsblrng As Range, cell As Range
Set vsblrng = Sheets(1).Range(a1:a50).SpecialCells(xlCellTypeVisible)
For Each cell In vsblrng.Cells
Congrats Excel Guru.
Regards
Prince dubey.
On Monday, 5 November 2012 22:58:39 UTC+5:30, Ayush Jain wrote:
Dear members,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
Oct'12. He has posted 66 posts in last month and helped forum members
through his excel
you will get what you want here ..
http://excelpoweruser.wordpress.com/2012/05/03/split-data-into-multiple-workbook/
Thanks
Rajan verma
On Tuesday, 6 November 2012 08:30:08 UTC+5:30, Somnath Khadilkar wrote:
On 11/4/12, Somnath Khadilkar khadi...@gmail.com javascript: wrote:
Dear SIrs,
Congrats Rajan
On Mon, Nov 5, 2012 at 10:29 PM, veerendra vanam
veerendra.va...@gmail.comwrote:
Congrats,
On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
Oct'12.
Congratulations ... Great going!!!
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 5 Nov 2012 22:57:57
To: excel-macrosexcel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Dear Rajan,
Congrats Dear..keep going...
Cheers.
Regards
Gawli Anil
On Tue, Nov 6, 2012 at 9:58 AM, v...@vabs.in wrote:
**
Congratulations ... Great going!!!
Sent on my BlackBerry® from Vodafone
--
*From: * Ayush Jain jainayus...@gmail.com
*Sender: *
Congrats Rajan
On Tue, Nov 6, 2012 at 10:23 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
*Congratulations* Rajan Sir.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com ||
Congratulation Rajan
On Tue, Nov 6, 2012 at 11:28 AM, Rajesh Nair nairra...@gmail.com wrote:
Congrats Rajan
On Tue, Nov 6, 2012 at 10:23 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
*Congratulations* Rajan Sir.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge
Dear All,
Good morning,
Here i got a problem
i cant work with macros in my system
how can instal it again?/
for exp
if i open a file with macros it is showing some security warning enable macros
and then enabled still it is not working.
please help me about this prob...
cheers
hI
go to file-options-trust center-trust center setting-macro setting-enable
macros..
On Tue, Nov 6, 2012 at 11:47 AM, DELIN FRANCIS delin_1...@yahoo.co.inwrote:
Dear All,
Good morning,
Here i got a problem
i cant work with macros in my system
how can instal it again?/
Paul,
I know the Rules of the forum...I had using this forum fro almost from long
time..appreciate your efforts in writing lengthy mail on this..
That exam itself designed by me..and I am not taking any exam ( Wrong
prediction) ..think positively ...this will nt have any loss for any one
29 matches
Mail list logo
