://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before
.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before printing, think about
https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out
.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http
.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before printing, think about the environment
/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http
://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us
://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join
this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros
...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http
email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit
options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups
email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp
options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups
, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P
@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages
-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http
/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before printing, think about
.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before printing, think about the environment.
--
Are you
://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before
.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before printing, think about the environment
.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before printing, think about the environment.
--
Are you
complete details in batches wise
1st record to 6 th record like wise.
Thanks,
Raj
On Sun, Oct 21, 2012 at 10:13 PM, ashish koul koul.ash...@gmail.comwrote:
Option Compare Database
Private Sub Command11_Click()
' Add microsoft Excel
' ADD aTIEVEX DATA OBJECT
Dim xla
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit
=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com
.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before printing, think about the environment
...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http
an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul
-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com
to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp
to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us
,
Regards,
Deepak
On Mon, Jan 28, 2013 at 8:42 PM, ashish koul koul.ash...@gmail.comwrote:
=SUM(IF($C$3:$C$10=G3,IF($D$3:$D$10,1,0)))
Press *CTRL+SHIFT+ENTER*
*
*
*Regards*
*Ashish*
On Mon, Jan 28, 2013 at 6:27 PM, Deepak Rawat
deepakexce...@gmail.comwrote:
Dear All,
Pls provide
, 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*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros
to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Hi
Its working at my place . Please find the working file attached
Regards
Ashish Koul
On Sat, Jan 26, 2013 at 10:58 PM, Eugene Bernard
eugene.bern...@gmail.comwrote:
Mr Koul,
Tested the macro, the result is not exactly matching requirement requested
by Chris.
Regards
Eugene
to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
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-macros?hl=en.
--
*Regards*
* *
*Ashish
try the attached file
Regards
Ashish Koul
On Thu, Jan 17, 2013 at 10:50 PM, Viswanathan Yoganathan
viswanathan.yoganat...@asia.xchanging.com wrote:
Hi,
** **
I have 150 files in my folder and all my files to be renamed starting with
A using VBA macro.
** **
Example
://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before
Deepak
Watch this video you will be able to solve your problem on your *OWN*
http://www.youtube.com/watch?v=27qh1i_kgCY
Regards
Ashish Koul
On Thu, Jan 17, 2013 at 5:18 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi,
thax for reply
but still unsolved in panchayat it should come 2 rather
then
ActiveCell.Offset(1, 1).Select
else
ActiveCell.Offset(1, 0).Select
endif
End If
Next sh
End Sub
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros
.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com
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*
*My Excel Blog http
...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http
try attached workbook
On Sun, Jan 13, 2013 at 2:31 PM, Smitha S R sperdwo...@gmail.com wrote:
HI,
Tried but returns #VALUE
On Sun, Jan 13, 2013 at 2:26 PM, ashish koul koul.ash...@gmail.comwrote:
Try this
=INDEX(Sheet1!C:C,MATCH(Sheet2!A2Sheet2!C2,Sheet1!$A$1:$A$5Sheet1!$B$1:$B$5,0
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*
*My Excel Blog http://www.excelvbamacros.com
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*
*My Excel Blog http
write UDF then
On Fri, Jan 11, 2013 at 5:15 PM, Satendra kumar
satendrakuma...@gmail.comwrote:
many many thanks sir,
but any other way with out helping column.
thankx
satendra
On Fri, Jan 11, 2013 at 5:06 PM, ashish koul koul.ash...@gmail.comwrote:
try the attachment see
...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http
@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*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp
://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before
(Merge).Range(a
Sheets(Merge).Range(a1048576).End(xlUp).Row + 1)
End If
Next
End Sub
I have changed the upper row now to 3 you have first two rows blank
On Fri, Jan 11, 2013 at 11:12 AM, ashish koul koul.ash...@gmail.com wrote:
Try this
Sub merge1()
Dim i As Long, z As Long
' add new sheet
-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us
, 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*
*My Excel Blog http://www.excelvbamacros.com
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*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel
://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog http://www.excelvbamacros.com/*
Like Us on
Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
Join Us on Facebook http://www.facebook.com/groups/163491717053198/
P Before
(ItemsListArchives).Range(D
Rows.Count).End(xlUp).Offset(7).value
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
Hi Group,
Merry Christmas to All
Try this macro to add Christmas Theme/Effect to Charts [?]
http://www.excelvbamacros.com/2012/12/macro-to-replace-markers-with-custom.html
Download Working File/Macro - https://www.box.com/s/02sfon6jloo7lpaj3s6c
Regards
Ashish Koul
On Tue, Dec 25, 2012 at 8
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/*
P Before printing, think about the environment.
--
Join official Facebook
, 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.excelvbamacros.com/*
P Before
://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise
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.excelvbamacros.com/*
P Before printing
+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https
.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
.
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*
*Visit*
*http
*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
try this =TEXT(B2,mmddhhmm) see if it helps
On Wed, Dec 19, 2012 at 10:36 PM, Bill Q ronsmith...@gmail.com wrote:
IE: January 8, 2012 9:01 would return a value of 201201080901.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
P Before printing, think about
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/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https
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.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http
.
--
*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 forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles
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?hl=en.
--
*Regards*
* *
*Ashish Koul
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.excelvbamacros.com/*
*http
://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise
+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https
+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https
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 environment.
--
Join official
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.excelvbamacros.com
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 forum @
https
, 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, think about the environment
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, think about the environment.
--
Join
= 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, think about the environment.
--
Join
how many sheets u have created in scanningprocess.xltm template
On Tue, Dec 11, 2012 at 11:15 PM, Laura Ann Dietrich
ldietri...@gmail.comwrote:
scanningprocess.xltm
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before
*
*
*
*
*
*
*
On Tue, Dec 11, 2012 at 11:20 PM, Laura Ann Dietrich
ldietri...@gmail.comwrote:
scanningprocess.xltm is one worksheet.
On Tue, Dec 11, 2012 at 12:47 PM, ashish koul koul.ash...@gmail.comwrote:
how many sheets u have created in scanningprocess.xltm template
On Tue, Dec 11, 2012
(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 official Facebook page of this forum
sorry forget to mention please change the path of template as per your
system and template name
C:\Documents and Settings\user\Desktop\sample.xltx
On Tue, Dec 11, 2012 at 11:31 PM, ashish koul koul.ash...@gmail.com wrote:
Hi Laura
*Please try this code*
Private Sub Worksheet_Change
.
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*
*Visit*
*http
...@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 environment.
--
Join official Facebook page of this forum @
https
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-macros?hl=en.
--
*Regards*
* *
*Ashish
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.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http
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.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http
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.
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http
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.excelvbamacros.com
...@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 environment.
--
Join official Facebook page of this forum @
https
*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
@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.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P
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 forum @
https://www.facebook.com
://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 forum @
https://www.facebook.com/discussexcel
FORUM RULES
-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.excelvbamacros.com/*
*http://www.accessvbamacros.com
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
satendrakuma...@gmail.comwrote:
Dear Sir,
I am not expert in vba, i am beginner vba so please me suggest me where is
add loop??
thankx
satendra
On Thu
whts in cc email
On Sun, Dec 2, 2012 at 10:55 AM, Satendra kumar
satendrakuma...@gmail.comwrote:
Thank you so much sir,
but cc email is pick up
thankx
satendra
On Sun, Dec 2, 2012 at 10:46 AM, ashish koul koul.ash...@gmail.comwrote:
Hi
Try the attached file
- change
401 - 500 of 1341 matches
Mail list logo