ks :
> 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 Tricks at http://exceldailytip.
gt;<><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish Koul*
*http://ww
http://www.susandoreydesigns.com/software/WordVBATechniques.pdf
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
--
Some important links for excel
http://www.susandoreydesigns.com/software/AccessTechniques.pdf
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
--
Some important links for excel
t.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><>
roups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
try something like
With ActiveSheet.PageSetup
.LeftFooter = "&""Arial,Regular""&10" & Format(Date, " dd, ")
End With
On Mon, Oct 24, 2011 at 2:16 PM, ashish koul wrote:
> http://www.cpearson.com/excel/headfoot.htm
m in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------
-------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
FO
on of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> ------
gt;
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and membe
in which format ur files are saved .xls or xlsx
On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer
wrote:
> Dear Ashish,
>
> I have copied it but when i am running the code it showing error msg pls
> help.
>
> On 3 November 2011 10:53, ashish kou
ecial xlValues
ask2.Close
End If
Next fil
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
On Thu, Nov 3, 2011 at 1:06 PM, wrote:
> **
> My files are saved in .xls format. But I am working in .xlxs.
>
>
> Sandeep Chhajer.
> Sent on my BlackBerryŽ from Vodafone
> --
like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing a
sponses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
&
; signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------
>
measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are
his forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ---------
-----
> To post to this group, send email to excel-macros@googlegroups.com
>
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
FORUM RULES (934+ members already BANNED
-------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
FORUM RULES (934+ membe
f a team.
If interested, pls. revert with your updated cv in a word format with
following details:
1-Total Exp
2-Exp in Dashboard/VBA
3-Current CTC
4-Expected CTC
5-Joining time required
Thanks,
Harneet Kaur
Concepts HR Pvt. Ltd.
harn...@conceptsconsultants.com
--
*Regards*
* *
*Ashish Kou
andle multiple projects simultaneously and
respond to changing priorities
Interested candidates can revert with their updated resume on the email id
mentioned below.
Regards,
Priya Kapoor
pr...@impetusconsultants.com
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before pri
Ltd.
Phone: 040-44326617
e-Mail: ram...@techpointsolutions.com
Visit Us: www.techpointsolutions.com
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accur
ss India.
Looking forward to hear from you.
Thanx & Regards
Manisha Bisht
Concepts HR Pvt Ltd
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, acc
one, if skill sets donot
match or already applied, kindly ignore the mail.
Regards,
Kavita Moger I Associate Consultant
CareerNet Consulting | URL: www.careernet.co.in
Email: kavita.mo...@careernet.co.in
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, thi
n for Change:
Notice Period:
Regards
Vishal. B
Colosseum Consulting.
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
: European Time.
Note: Once I have your updated profile , I will call you share with you
more information.
Looking forward to have your updated CV.
With thanks & regards
Utpal Das
Principal Consultant
Endeavour Consultancy Services
Email: ut...@ecsindia.co.in
--
*Regards*
* *
*Ashish
rsonal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code
Access + (Experience to create
automation to support financial team of the company)*
** **
*Thanks and Regards"*
Ashish Mishra
*Lead IT *Recruiter@*New*star* * **Consulting** *
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think abou
no-932895
TekShapers India
www.tekshapers.com
i...@tekshapers.com
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor threa
tion in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ev
owledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not
and provide solutions
Generate Ad Hoc reports- Sql Knowledge is required.
Exp- 2.4yrs
B.E/Btech, M.E/Mtech, Msc, MCA
Interviews are happening on saturday, Please send your CV to -
tgo...@teksystems.com
or
Call Tanya Gowda
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P
be a quick learner and target oriented.
Send me your updated resume at anurad...@globali.in with subject as " Data
Operations Manager - Delhi "
>
Or would really appreciate if any suitable reference for the same can be
>
provided ..
>
>
Regard's,
>
Anuradha Gusain
development/analysis
* Strong analytical, writing, verbal and written communication skills
Regards,
Aditi Ghosh
Origin Consulting Services
E: ad...@originhr.in
W: www.originhr.in
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment
university
Location: Bangalore,Gurgaon
Write with your updated resume along following details
Present CTC, Expected CTC, Notice Period to
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
FORUM RULES (934+ members already
eive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
>
do you want to hide rows with error value or not
On Fri, Dec 2, 2011 at 4:40 PM, AbdulGani Shaikh wrote:
> It gives error, screenshot of which is attached herewith
> Regards
>
> On Fri, Dec 2, 2011 at 12:20 PM, ashish koul wrote:
>
>> Sub hide_data()
>> Applica
tures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------
> To post to this group, send email to excel-macros@googleg
Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ---
sible for any loss.
>
>
> ------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
P Before printing,
e responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any lo
ion in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> s
7;t ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------
> To post to this group, send email to excel-macros@goo
ions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a wor
't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-m
you very much Mr. Ashish Koul, its very useful and interesting files.
>
>
> On Fri, Oct 19, 2012 at 7:53 PM, Sam Mathai Chacko wrote:
>
>> This is very good Ashish. Thanks for sharing.
>>
>> Regards,
>> Sam
>>
>> On Fri, Oct 19, 2012 at 7:20 PM, ashis
are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
e Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/
ved this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.
Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To u
roup, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www
sible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+u
ups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?
n my file it is not working
> and one more thing ,,,
> I don't understand that "ckrng" which you used in that formula please make
> me clear that "ckrng"
>
>
> thanks regards
>
> *Delin.F*
>
>
>
> --
to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-m
answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive t
to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/e
ribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/
are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> e
responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubsc
t; To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P
message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this gro
in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegrou
t; members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
>
Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subsc
to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.
s group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excel
from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing,
glegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this foru
LEFT(A1,2)&RIGHT(A1,LEN(A1)-4)
On Thu, Nov 29, 2012 at 8:17 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> PH1106220
>
> AK0721911
>
> AG0600641
>
> AK0915631
>
> AK1015631
>
> AK1015631
>
> AK0915631
>
> AK07
To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Be
scribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.c
d email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing, think about the envi
re subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/
.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish
Hi
Try the attached file
- change the folder path in code.
Regards,
Ashish Koul
On Fri, Nov 30, 2012 at 10:15 AM, Satendra kumar
wrote:
> Dear Sir,
>
> I am not expert in vba, i am beginner vba so please me suggest me where is
> add loop??
>
>
> thankx
> satendra
whts in cc email
On Sun, Dec 2, 2012 at 10:55 AM, Satendra kumar
wrote:
> Thank you so much sir,
>
> but cc email is pick up
>
> thankx
> satendra
>
>
> On Sun, Dec 2, 2012 at 10:46 AM, ashish koul wrote:
>
>>
>> Hi
>>
>> Try th
e = attach1
End If
End Sub
On Sun, Dec 2, 2012 at 11:12 AM, Satendra kumar
wrote:
> Dear sir,
>
> i want same mail send in email Cc address.
>
>
>
> On Sun, Dec 2, 2012 at 10:59 AM, ashish koul wrote:
>
>> whts in cc email
>>
>> On Sun, Dec 2, 2012 at 1
ial data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
&g
@
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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.
> 2) D
righted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA M
any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubs
, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvba
iscussexcel
>
> FORUM RULES
>
> 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.
> 2) Don't post a question in the thread
u are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http
gt; To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Befor
get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allo
any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@g
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, sen
to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/
; You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
roup.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
EL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
-
hing Then*
> *Set wsNew = Sheets(Target.Text)*
> *If wsNew Is Nothing Then Sheets.Add().Name = Target.Text*
> *End If*
> *End Sub*
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing, t
l Target As Range)*
>>> *Dim wsNew As Worksheet*
>>> *If Target.Cells.Count > 1 Then Exit Sub*
>>> * *
>>> *On Error Resume Next*
>>> *If Not Intersect(Target, Range("A6:A99")) Is Nothing Then*
>>> *
how many sheets u have created in "scanningprocess.xltm" template
On Tue, Dec 11, 2012 at 11:15 PM, Laura Ann Dietrich
wrote:
> scanningprocess.xltm
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before pr
End If
*
*End If*
*End Sub*
*
*
*
*
*
*
On Tue, Dec 11, 2012 at 11:20 PM, Laura Ann Dietrich
wrote:
> "scanningprocess.xltm" is one worksheet.
>
>
> On Tue, Dec 11, 2012 at 12:47 PM, ashish koul wrote:
>
>> how many sheets u have created in "scanningproc
sNew = Sheets(Target.Text)
If wsNew Is Nothing Then
Set sht = Sheets.Add(Type:="C:\Documents and
Settings\user\Desktop\sample.xltx", After:=Sheets(Sheets.Count))
sht.Name = Target.Text
End If
End If
End Sub
Regards
Ashish Koul
--
Join officia
801 - 900 of 1436 matches
Mail list logo