Hello everyone,
I hope the book which is being shared in this thread is free ebook and not
the paid one.
I am strongly against sharing pirated copies without the consent of author.
Let me know if you have any queries.
Thanks.
Regards
Ayush Jain
Group Manager Microsoft MVP
On
Hi Noorain,
Pls send me the file Excel VBA Ebook 2007 on prkha...@gmail.com
Thanks
On Thursday, May 31, 2012 1:10:54 PM UTC+4, NOORAIN ANSARI wrote:
Dear All,
I have send ebook on your email ID.
Please check and confirm me.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
Dear Mr Ansari
Please send it to me .
(My email : sonnguye...@gmail.com)
Thanks a lot
Son
2012/5/31 NOORAIN ANSARI noorain.ans...@gmail.com
Dear Tarun,
I have send Excel macro Ebook.
Pls check
On Thu, May 31, 2012 at 2:57 PM, Tarun Mondal
tarunmondal1...@gmail.comwrote:
Sir ,
Vodafone
-Original Message-
From: son nguyen sonnguye...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 1 Jun 2012 11:29:49
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MACRO
Dear Mr Ansari
Please send it to me .
(My email
Hi Noorain,
Please send me the files at midearfam...@gmail.comashwani.agniho...@gmail.com
Regards
Vijay
On Wed, May 30, 2012 at 11:27 AM, ashwani agnihotri
ashwani.agniho...@gmail.com wrote:
Hi Noorain,
plz send me the files at ashwani.agniho...@gmail.com
thanks...
On Wed, May 30,
Hi Noorain,
Please send to my mail id
Regards,
Santhosh
On 5/30/12, vijayKumar midearfam...@gmail.com wrote:
Hi Noorain,
Please send me the files at
midearfam...@gmail.comashwani.agniho...@gmail.com
Regards
Vijay
On Wed, May 30, 2012 at 11:27 AM, ashwani agnihotri
me 2 plz
From: pawel lupinski lupins...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Wednesday, May 30, 2012 5:39 AM
Subject: Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files
thanks
Pawel
@googlegroups.com
*Sent:* Wednesday, May 30, 2012 5:39 AM
*Subject:* Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files
thanks
Pawel
*From:* Aruna jayaram aruna2...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tuesday, May 29, 2012 8:29 PM
*Subject:* Re: $$Excel-Macros
-Macros$$ MACRO
Hi Noorain
Please send the files
thanks
Pawel
*From:* Aruna jayaram aruna2...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tuesday, May 29, 2012 8:29 PM
*Subject:* Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files for excel 2007.
thanks
, LAKSHMAN PRASAD
lakshman_...@yahoo.comwrote:
me 2 plz
*From:* pawel lupinski lupins...@yahoo.com
*To:* excel-macros@googlegroups.com excel-macros@googlegroups.com
*Sent:* Wednesday, May 30, 2012 5:39 AM
*Subject:* Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files
thanks
Sir , pls send me my email id jmothi...@yahoo.com
Thanks with
Mothilal.J
On Wed, May 30, 2012 at 8:25 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Hi Joseph,aruna,lupinskip and anjali,
I have send VBA Ebook 2007(O'Rellay) on your email ID.
Pls check and confirm.
--
Thanks
Dear All,
I want to learn MACRO's from basic so kindly give me some material for the
same.
Thanks Regards,
K SAGAR
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Hi Noorain,
Send same for Excel 07 Please.
Thanks
MAnGesh
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sagar,
Please find attached study material of Basic Macro and follow excel-macro
group on regular basis.
--
Thanks regards,
Noorain Ansari
Dear Mangesh,
File is heavy so, I have send u on your email ID
Please check.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 6:11 PM, Mangesh Dayne mangesh.da...@gmail.comwrote:
Hi Noorain,
Send same for Excel 07 Please.
@googlegroups.com
Subject: $$Excel-Macros$$ MACRO
Dear All,
I want to learn MACRO's from basic so kindly give me some material for the
same.
Thanks Regards,
K SAGAR
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
*Subject:* $$Excel-Macros$$ MACRO
** **
Dear All,
** **
I want to learn MACRO's from basic so kindly give me some material for the
same.
** **
** **
Thanks Regards,
** **
K SAGAR
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MACRO
Dear Mangesh,
File is heavy so, I have send u on your email ID
Please check.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 6:11 PM, Mangesh Dayne mangesh.da
Hi
Can you pls send the files for excel 2007.
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sagar,
Please find attached study material of Basic Macro and follow excel-macro
group on regular basis.
--
Thanks regards,
Noorain Ansari
Hi Noorain
Please send the files for excel 2007.
thanks
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sagar,
Please find attached study material of Basic Macro and follow excel-macro
group on regular basis.
--
Thanks regards,
Noorain Ansari
Hi Noorain
Please send the files
thanks
Pawel
From: Aruna jayaram aruna2...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, May 29, 2012 8:29 PM
Subject: Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files for excel 2007.
thanks
Hi Joseph,aruna,lupinskip and anjali,
I have send VBA Ebook 2007(O'Rellay) on your email ID.
Pls check and confirm.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
Noorain Sir,
Can you please send me the file too in my mail ID, the file that you share
with Mangesh.
mail:- drdeva...@gmail.com
Thanks Regards,
*Deba Ranjan P*
On Wed, May 30, 2012 at 8:25 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Hi Joseph,aruna,lupinskip and anjali,
Noorain Bhai,
Please send it to me, I'll be thankful to you.
With Best Regards
Anirban
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Hi Noorain,
plz send me the files at ashwani.agniho...@gmail.com
thanks...
On Wed, May 30, 2012 at 10:48 AM, Anirban Roy excelanir...@gmail.comwrote:
Noorain Bhai,
Please send it to me, I'll be thankful to you.
With Best Regards
Anirban
--
FORUM RULES (986+ members already BANNED
Dear Excel Guru,
I have a protected sheet where some cells are unprotected.
i want a macro which can make all unprotected cells to zero value.
Thanking you in advance.
--
Regards,
Sandeep Kumar Chhajer.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
-macros@googlegroups.com
Subject: $$Excel-Macros$$ macro to make unlocked cell value zero
Dear Excel Guru,
I have a protected sheet where some cells are unprotected.
i want a macro which can make all unprotected cells to zero value.
Thanking you in advance.
--
Regards,
Sandeep Kumar
Subject: RE: $$Excel-Macros$$ macro to make unlocked cell value zero
Protect your sheet and Run this :
Sub MTest()
ActiveSheet.UsedRange.Value = 0
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros
: 28 May 2012 8:10
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ macro to make unlocked cell value zero
Thanks Rajan I will try it!
Sandeep Chhajer.
Sent on my BlackBerryR from Vodafone
_
From: Rajan_Verma rajanverma1...@gmail.com
Sender: excel-macros
hi,
i tried the code provided by the group in the sheet attached. i am getting
error message subscript out of range.
Refreshing the problem again: tracker to update the off days as per
employee's choice with not more than 8 employees on off on a particular day
and the employee cannot have
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prashant pawle
Sent: 08 May 2012 12:43
To: Excel Helper
Cc: prashant pawle
Subject: $$Excel-Macros$$ Macro for data sorting
Dear Experts,
Please ignore previous mail
Dear Experts,
Kindly advise macro to sort data by dt of openingMacro shd run if the
range of data is changed
Thanks in advance
Regards,
Prashant
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Dear Experts,
Please ignore previous mail , correct file attached here , please help on
below
Kindly advise macro to sort data by dt of openingMacro shd run if the
range of data is changed
Thanks in advance
Regards,
Prashant
--
FORUM RULES (986+ members already BANNED for violation)
Dear Prashant,
Please use below code..
*Sub Data_sorting()*
*Sheet2.Activate*
*Cells.Select*
*Selection.Sort Key1:=Range(E2), Order1:=xlAscending, Header:=xlYes, _*
*OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _*
*DataOption1:=xlSortNormal*
*End Sub*
See
many thanx noorain
On Tue, May 8, 2012 at 1:12 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Prashant,
Please use below code..
*Sub Data_sorting()*
*Sheet2.Activate*
*Cells.Select*
*Selection.Sort Key1:=Range(E2), Order1:=xlAscending, Header:=xlYes, _*
*OrderCustom:=1,
Hi
Try this
Sub kTest()
Dim ka, k(), i As Long, c As Long, n As Long, Hdr, x
Dim wks As Worksheet, Flds
Hdr = Array(NAME, Specialty_name, Office_name, Address_1,
Address_2, _
Address, Phone_number_1, Fax_number)
ka =
Kris,
You are amazing and gracious for your help and very quick repsonse. Thank
you millions!
John
On Tue, May 8, 2012 at 10:09 AM, Krishna Kumar krishnak...@gmail.comwrote:
Hi
Try this
Sub kTest()
Dim ka, k(), i As Long, c As Long, n As Long, Hdr, x
Dim wks As Worksheet,
John
You are welcome. Thanks for the feedback
Kris
ExcelFox http://www.excelfox.com/forum/forum.php
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
Replace
ReDim k(1 To UBound(ka, 1) * (UBound(Hdr) + 1) + UBound(Hdr) + 1, 1 To 1)
with
ReDim k(1 To 1, 1 To 1)
Kris
ExcelFox http://www.excelfox.com/forum/forum.php
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Absolutely fantastic! Thank you for your generous help.
John
On Tue, May 8, 2012 at 11:07 AM, Krishna Kumar krishnak...@gmail.comwrote:
Replace
ReDim k(1 To UBound(ka, 1) * (UBound(Hdr) + 1) + UBound(Hdr) + 1, 1 To 1)
with
ReDim k(1 To 1, 1 To 1)
Kris
ExcelFox
Sorry ... I didn;t see the Macro in the attachment.
thanks,
Tony
On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote:
Hi,
Check the attachment.
Regards,
MARIES.
On Fri, May 4, 2012 at 12:27 PM, Tony Wu wumu...@gmail.com wrote:
Hello,
I have a file for the forecast demand,
Hi Tony,
I have done by formula... Just check the sheets cells. There is no Macro
codes inside.
Regards,
MARIES.
On Mon, May 7, 2012 at 5:13 PM, Tony Wu wumu...@gmail.com wrote:
Sorry ... I didn;t see the Macro in the attachment.
thanks,
Tony
On Saturday, May 5, 2012 9:23:46 AM UTC-4,
Hi Maries,
I have checked the file but all numbers, no formula inside ... hence, the
macro needs to do something on the data itself not to create another sheet.
The sample I provided is to show what result I want to see not meaning it
will be 2 sections of the data, I guess using formula will
Hi Seema,
See attachment
On Fri, May 4, 2012 at 8:40 PM, Seema vasee...@gmail.com wrote:
Hello,
Please help in getting a macro for the problem in the sheet attached.
Regards
Seema.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Hello,
I have a file for the forecast demand, some parts have substitution, what I
need is if the part has substitution, the original demand will be added to
the new part and original demand will be zero out, please see the attached
file for reference.
Thanks,
Tony
--
FORUM RULES (986+
*Hi Experts,
Is there any trick or any software to create macros coding. i have seen
many from the experts that they easily run the macros with the coding.
Please do let me the prevailing coding how to write the coding.
*
Thanks in advance. Hope you all help me out for the coding.
Thanks
You can record macros in Excel. To know how to record macros, just do a
google search.
REgards,
Sam Mathai Chack
On Sat, Apr 28, 2012 at 1:42 PM, Deba Ranjan drdeva...@gmail.com wrote:
*Hi Experts,
Is there any trick or any software to create macros coding. i have seen
many from the
*Hi sir,
I tried many times but the coding never comes, i mean the appropriate
coding never comes. kindly sort out.
*
Thanks Regards,*
*
*Deba Ranjan P***
On Sat, Apr 28, 2012 at 2:17 PM, Sam Mathai Chacko samde...@gmail.comwrote:
You can record macros in Excel. To know how to
What do you mean by appropriate code?
Regards,
Sam
On Sat, Apr 28, 2012 at 3:42 PM, Deba Ranjan drdeva...@gmail.com wrote:
*Hi sir,
I tried many times but the coding never comes, i mean the appropriate
coding never comes. kindly sort out.
*
Thanks Regards,*
*
*Deba Ranjan P***
*Hi sir,
See the below coding, you will find that there are so many steps and so
on. Can we run like so in the macros, if so please tell me the procedure to
that.
*
eg:-
Sub Main()
' Inserts random numbers on the active worksheet
Dim Counter As Integer
Dim RowMax As Integer, ColMax
@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: Apr/Sat/2012 04:11
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro coding
Hi sir,
See the below coding, you will find that there are so many steps and so
on. Can we run like so in the macros, if so please tell me the procedure
-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Macro coding
** **
*Hi sir,
See the below coding, you will find that there are so many steps and so
on. Can we run like so in the macros, if so please tell me the procedure to
that.
*
eg:-
Sub Main()
' Inserts random numbers
Dear Pankaj,
Please see below link, Hope it will help to you
http://www.xtremevbtalk.com/showthread.php?t=236989
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On
Files contains user ids..
Regards,
Prabhat S
--
FORUM RULES (986+ members already BANNED for violation)
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
I need at least one text file.. can you share?
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prabhat.shrivasta...@gmail.com
Sent: Apr/Sat/2012 12:27
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Macro
Actually these files are thr part of some imported system reports of ma bank
which can not be transit outside the bank,
Hence can't share, we create a sample file at our own by giving subject as below
Report name date
USER IDS DATETIMEREASON
Pls copy paste these details in text
Dear Experts,
I'm preparing a macro to checks some reports, I have a folder that contains
some text files with user ids other details with different files names
an excel sheet contains the user ids. Now i wanna know if any of user ids
mentioned in excel sheet are matching with user ids
Hi
Can you send your text file
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prabhat.shrivasta...@gmail.com
Sent: Apr/Fri/2012 09:46
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to search text based on an array
Dear
Hi rajan,
Thks fot yr revert, there arnd morethan 10 text files with diffrent headers but
all files having the user ids as mentioned on excel sheet.
Awaitaing yr response in this..
Regards,
Prabhat S
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread
-Macros$$ Macro to search text based on an array
Hi rajan,
Thks fot yr revert, there arnd morethan 10 text files with diffrent headers
but all files having the user ids as mentioned on excel sheet.
Awaitaing yr response in this..
Regards,
Prabhat S
--
FORUM RULES (986+ members already BANNED
Dear experts,
I need a macro for following requirement.
Please refer the attached Excel sheet. If there is a value in the cell
C5(Quantity), formula of cell F5(Amount) should be =C5*E5 otherwise cell F5
should be blank.
This should be repeat to each row which has value in Column C.
Thank you.
can,
As long as ever you can.” - John Wesley
-
From: Dilan De Silva dila...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tue, April 10, 2012 9:47:29 AM
Subject: $$Excel-Macros$$ Macro to calculate amount
Dear experts
*Subject:* $$Excel-Macros$$ Macro to calculate amount
Dear experts,
I need a macro for following requirement.
Please refer the attached Excel sheet. If there is a value in the cell
C5(Quantity), formula of cell F5(Amount) should be =C5*E5 otherwise cell F5
should be blank.
This should
*-
--
*From:* Dilan De Silva dila...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tue, April 10, 2012 9:47:29 AM
*Subject:* $$Excel-Macros$$ Macro to calculate amount
Dear experts,
I need a macro for following requirement
=E5*C5*1
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: Apr/Tue/2012 07:52
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to calculate amount
There's no macro required.
you can use a simple formula
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to calculate amount
If you REALLY need a macro, let me know.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Dilan De Silva mailto:dila...@gmail.com
Sent: Tuesday, April 10, 2012 8:47 AM
the people you can,
As long as ever you can.” - John Wesley
-
From: Dilan De Silva dila...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tue, April 10, 2012 10:27:05 AM
Subject: Re: $$Excel-Macros$$ Macro to calculate amount
If
End Sub
** **
** **
Rajan.
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *dguillett1
*Sent:* Apr/Tue/2012 08:09
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Macro to calculate amount
Dear All,
Hope somebody can help me to create a macro to:
print the sheet in pdf,
name the PDF as cell value 'E4'
and save the same into location : C:\Users\FAISAL\Desktop\PRSD
Please find the attached sheet for your reference.
Thanks in advance for your valuable assistance.
On
: $$Excel-Macros$$ Macro to Print the sheet in PDF and save in a
folder.
Dear All,
Hope somebody can help me to create a macro to:
print the sheet in pdf,
name the PDF as cell value 'E4'
and save the same into location : C:\Users\FAISAL\Desktop\PRSD
Please find the attached
Of *Excel_Lover
*Sent:* Apr/Mon/2012 05:22
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Macro to Print the sheet in PDF and save
in a folder.
** **
Dear All,
** **
Hope somebody can help me to create a macro to:
** **
print the sheet in pdf
Which verion of excel are you using.. can you send screenshot.?
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Excel_Lover
Sent: Apr/Mon/2012 07:09
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to Print the sheet in PDF
Ok,
Just remove the Blank line in between RED Lines, error is just because of
all lines are not in continuous ,
Rajan.
From: Excel_Lover [mailto:idforex...@gmail.com]
Sent: Apr/Mon/2012 07:25
To: rajanverma1...@gmail.com
Subject: Fwd: $$Excel-Macros$$ Macro to Print the sheet in PDF
Dear All,
please find the below mentioned Macro which I recorded to print a sheet in
PDF,
Sub test()
Application.ActivePrinter = PDFCreator on Ne01:
ExecuteExcel4Macro _
PRINT(2,3,3,12,PDFCreator on Ne01:,,TRUE,,FALSE)
End Sub
Can somebody please modify the macro which
Dear excel guru,
I want a macro to insert 100 sheets (all are same/smilar copy of sheet 1) o
sheet will be named 2...3..4...and so on!
Please help.
Thanks Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
Hi,
Try Below Code,
Sub Sheet1Multiplecopy()
Dim i As Integer
i = 1
For i = 1 To 100
Sheets(Sheet1).Select
Sheets(Sheet1).Copy After:=Sheets(i)
ActiveSheet.Name = i
Next
End Sub
Regards,
MARIES.
On Sat, Mar 31, 2012 at 10:11 AM, chhajersand...@gmail.com wrote:
Dear excel guru,
: $$Excel-Macros$$ Macro for 100 sheets
Dear excel guru,
I want a macro to insert 100 sheets (all are same/smilar copy of sheet 1) o
sheet will be named 2...3..4...and so on!
Please help.
Thanks Sandeep Chhajer.
Sent on my BlackBerryR from Vodafone
--
FORUM RULES (986+ members already BANNED
Sorry, Sandeep, I did not immediately see that you needed copies of another
sheet. Maries has you.
Asa
-Original Message-
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Saturday, March 31, 2012 12:40 AM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Macro for 100
@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Macro for 100 sheets
Hi Sandeep,
sheets.Add count:=100
Check help for additional options.
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chhajersand...@gmail.com
Sent: Friday
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for 100 sheets
Hi,
Try Below Code,
Sub Sheet1Multiplecopy()
Dim i As Integer
i = 1
For i = 1 To 100
Sheets(Sheet1).Select
Sheets(Sheet1).Copy After:=Sheets(i)
ActiveSheet.Name = i
Next
End Sub
Regards,
MARIES.
On Sat, Mar 31
needed copies of another
sheet. Maries has you.
Asa
-Original Message-
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Saturday, March 31, 2012 12:40 AM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Macro for 100 sheets
Hi Sandeep,
sheets.Add count:=100
H Friends,
I HAVE TO RENAME 72 SHEETS AND I AM USING BELOW CODES FOR RENAME SHEET.
BUT A1 RANGE CHARACTER TOO LONG I WANT RENAME EACH SHEETS HAS 20 CHARACTER
OF RANGE A1.
PLS CHANGE THE FORMULA AND SEND ME BACK.
THANKS IN ADVANCE.
Sub RenameTabsHandlingNulls()
' Renames all worksheet tabs
Dear Amresh,
Please try it..
Sub RenameTabsHandlingNulls()
' Renames all worksheet tabs with each worksheet's cell A1 contents.
'If cell A1 has no content, then the tab is named as Default
*Dim sh As String*
For i = 1 To Sheets.Count
*sh = Left(Worksheets(i).Range(A1).Value, 20)*
If
Dear Amresh,
Please check it if this code is not working send a sample sheet
On Fri, Mar 30, 2012 at 8:30 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Amresh,
Please try it..
Sub RenameTabsHandlingNulls()
' Renames all worksheet tabs with each worksheet's cell A1 contents.
'If
, 2012 10:00 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MACRO CODE REQUIRED
Dear Amresh,
Please try it..
Sub RenameTabsHandlingNulls()
' Renames all worksheet tabs with each worksheet's cell A1 contents.
'If cell A1 has no content, then the tab is named as Default
Dim
Can anyone please help me on this?
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 25 March 2012 18:33
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to sort excel data email to party
Dear
Dear All,
I need your expert help...
Please find attached sample file. Following things are expected to be done;
1) In first sheet there are data that needs to be sorted work shop wise.
2) In the second sheet email ids are mentioned where we need to send those
sorted data per
hi venkat,
appreciating for your assistance..
actually i have stored some html files in a particular folder and i wants
to search and hyperlink the path of that file in the sheet.
Thanks Regards
On Fri, Mar 23, 2012 at 9:49 AM, Venkat CV venkat1@gmail.com wrote:
Hi ,
See below link..
Hi ,
See below link..
http://www.pcreview.co.uk/forums/re-search-html-access-vba-t3992723.html
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Thu, Mar 22, 2012 at 12:13 AM, Raj Mahapatra rajafs...@gmail.com wrote:
hi all
i am looking for some vba codes which will search html files (bases file
Dear all,
Please find my attachment ( I know asking question in this way is a violation
of our forum rule but sorry I don't have data card to copy the queries from
excel)
Thanking you in advance.
Sandeep Chhajer.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
Dear Sandeep,
Please explain more..
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Wed, Mar 21, 2012 at 9:40 PM, chhajersand...@gmail.com wrote:
Dear all,
Please find my attachment ( I know
hi all
i am looking for some vba codes which will search html files (bases file
names in the sheet) from specified locations and paste the path of the same
file as hyperlink in the sheet
Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles.
I have a macro that will hide unused rows in a spreadsheet, print the
active sheet, then unhide the rows.
Spreadsheet is from cell A1 to P175. Base info is recorded in various
cells on rows 1 to 4.
Cells 5 to 16 display output.
The main Data input starts in cell A18 to G 167. A18 is a
, contiguous range, delete the sheet ---for a contiguous
printout)
Hope this helps.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mel
Sent: Monday, March 19, 2012 2:27 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to hide rows
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aju Chacko
Sent: Sunday, March 11, 2012 10:08 PM
To: excel macro forum
Subject: Fwd: $$Excel-Macros$$ Macro inside 'add-in' not running while
executing button in add-in tab
Please help the code reside inside the add-in module the password
I don't understand your need and WHY
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Rajesh K R
Sent: Thursday, March 15, 2012 12:16 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for format table
Hi
Thank u
).Row
Cells(fr, i).Resize(lr).Copy Cells(2, i + 6)
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Rajesh K R
Sent: Tuesday, March 13, 2012 8:50 AM
To: excel-macros
Subject: $$Excel-Macros$$ Macro for format table
Hi
Thank u for ur reply, still I need some more changes in the code, pls
check the attached xl file, it will show step by step what to do.pls
make the necessary change in the code for getting the result.
Sub CopyColumnsToTableSAS()
Dim i As Integer
Dim fr As Long
Dim lr As Long
'col A
Cells(2,
Hi experts
Find the attached file,and help me to create a macro to format a table
from the data given.
My idea to solve this
select column A:E, paste in G1
Select blank cells in column B ,here B2:B26 Deletethem
Repeat the sale in next columns
Regards
Rajesh Kainikkara
--
FORUM
Cells(2, i + 6)
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Rajesh K R
Sent: Tuesday, March 13, 2012 8:50 AM
To: excel-macros
Subject: $$Excel-Macros$$ Macro for format table
Hi experts
Find the attached file,and help me
Hi,
I don't known if the message is to go to Ayush, if it is, please Ayush,
could you remove files sent to the discussion's subject since it seems to
be files with confidential infos.
Please find the user request below. If it's not Ayush, could someone else
in charge of the forum do it?
Regards,
701 - 800 of 1194 matches
Mail list logo
