Sub sample_code()
Application.ScreenUpdating = False
Dim a As Range
Dim SrchRnga As Range
Dim i As Long
Set SrchRnga = Sheets(1).Range(b1: b
Sheets(1).Range(b65356).End(xlUp).Row)
For i = 3 To Sheets(table).Range(b65356).End(xlUp).Row
Do
Set a = SrchRnga.Find(Sheets(table).Range(b i).Value,
@googlegroups.com
Subject: $$Excel-Macros$$ macro: delete base on table
Hi All,
I'd like to ask you for favour, can you help me with these. I have a table
code with codes. From this table I'd like to excclude all codes for table
to delete (tab table). Right now I'm using or function in vba
@googlegroups.com'
Subject: RE: $$Excel-Macros$$ macro: delete base on table
Hi,
Use this Code, Just Create Two Name Ranges,
Sheet1!B2=rngRange
Sheet2!B2 = MapDelete
Sub ExcludeFromList()
Dim objDicMap As Object
Dim VarArrData
Dim VarArrResult
Dim rngCell
Dear Group,
I require the Macro in Add-in form which convert the full amount into the
million e.g. if I want to convert the figure 1,000,000 to million it will
show as 1.000.
Procedure should 1,000,000 enter as 1,000,000mm it automatically convert
the figure as 1.000.
Regards,
Aamir Shahzad
--
I posted this yesterday...it seems it did not get through..so posting once
again
Hello All,
I am using Excel 2010. I have a List of Names in Sheet name “List”
I have attached a file with two modules.
*Module1* Macro creates separate sheet with the names listed in the sheet
name List and
can u create the sample pivot table in the attached sheet and send it back
to us
On Mon, Oct 1, 2012 at 10:40 PM, Rashid Khan prkha...@gmail.com wrote:
I posted this yesterday...it seems it did not get through..so posting once
again
Hello All,
I am using Excel 2010. I have a List of Names
I posted this yesterday...it seems it did not get through..so posting once
again
Hello All,
I am using Excel 2010. I have a List of Names in Sheet name “List”
I have attached a file with two modules.
*Module1* Macro creates separate sheet with the names listed in the sheet
name List and
I tried it its giving error . I would suggest create pivot table manually
then use macro to apply filter and copy the filter pivot table to new sheet
etc,
can you create pivot table and send the file
On Mon, Oct 1, 2012 at 10:50 PM, Rashid Khan prkha...@gmail.com wrote:
I posted this
Hi Experts,
Can anyone let me know how populate running time of macro.
Ex: If I run any macro, At the end of macro I should get how much time it took
to complete macro.
Regards,
Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
Hi
Please refer following link for more details:
http://www.mrexcel.com/archive/VBA/20164.html
Rgds//Vabs
On Wednesday, September 26, 2012 3:40:17 PM UTC+5:30, Krishnaraddi V.
Madolli wrote:
Hi Experts,
Can anyone let me know how populate running time of macro.
Ex: If I run any
printing this message
From: Vabz [mailto:v...@vabs.in]
Sent: 09/26/2012 16:28
To: excel-macros@googlegroups.com
Cc: Krishnaraddi V. Madolli
Subject: Re: $$Excel-Macros$$ Macro running time
Hi
Please refer following link for more details:
http://www.mrexcel.com/archive/VBA/20164.html
Rgds//Vabs
I don't know exactly because I do not program powerpoint. This is an
Excel Macros grou, after all.
However it would be something like
Picture.left = (slide.width - picture.width)/2
picture.top = (slide.height - picture.height)/2
It may need ActiveWindow.width rather than slide.width
hth
-...@**googlegroups.com]
*On Behalf Of *Suyog
*Sent:* 17 September 2012 4:46
*To:* excel-...@googlegroups.com
*Subject:* $$Excel-Macros$$ Macro for outlook
** **
Hello All,
I have merged two macros to avoid sending mail either without subject
or without attachment via outlook.
My
]*
* *
*From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com]
*On Behalf Of *Suyog
*Sent:* 17 September 2012 4:46
*To:* excel-...@googlegroups.com
*Subject:* $$Excel-Macros$$ Macro for outlook
** **
Hello All,
I have merged two macros to avoid sending mail either without
If*
*End Sub*
* *
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Suyog
*Sent:* 17 September 2012 4:46
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros
*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *Suyog
*Sent:* 17 September 2012 4:46
*To:* excel-...@googlegroups.com javascript:
*Subject:* $$Excel-Macros$$ Macro for outlook
** **
Hello
Hello All,
I have merged two macros to avoid sending mail either without subject or
without attachment via outlook.
My problem is this macro is currently working for attach word only this
should work for other word also like include, enclose also.
I'm not expert of macro but I learned little
-Macros$$ Macro for outlook
Hello All,
I have merged two macros to avoid sending mail either without subject or
without attachment via outlook.
My problem is this macro is currently working for attach word only this
should work for other word also like include, enclose also.
I'm not expert
chow rahul8...@gmail.com
To: excel-macros@googlegroups.com
Sent: Fri, September 7, 2012 7:38:20 AM
Subject: $$Excel-Macros$$ Macro to filter data based on Time
Hi All,
I want a Macro to filter data based on Time.
If Startdate and Enddate containns timings of 12:30PM to 1:15 PM(lunch
time) and
8
*-
--
*From:* rahul chow rahul8...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Fri, September 7, 2012 7:38:20 AM
*Subject:* $$Excel-Macros$$ Macro to filter data based on Time
Hi All,
I want a Macro to filter data based on Time
I think you will need to this file
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rahul chow
Sent: 07 September 2012 5:08
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro
@googlegroups.com
*Sent:* Fri, September 7, 2012 10:06:19 AM
*Subject:* Re: $$Excel-Macros$$ Macro to filter data based on Time
Hi Paul,
Thanks for your quick reply.
But the macro is not working.
Here i am providng littile bit of explanation about my query.
In the attached fourth row contains
*-
--
*From:* dguillett1 dguille...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Thu, August 30, 2012 10:17:10 AM
*Subject:* Re: $$Excel-Macros$$ Macro to Calculate a total upon a
condition
Your method of looping is inefficient when compared to FIND.
Don Guillett
Microsoft Excel
From: Krishnaraddi V. Madolli
Sent: Thursday, August 30, 2012 8:37 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to consolidate multiple sheets.
Hi Experts,
I have 5 excel workbooks each consisting of 3 sheets called: Climate Data,
Product Data Salary Details
All
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Macro to Calculate a total upon a condition
Dear friends,
I want to programme a macro to calculate a total.
Refer *both sheets* of attached Excel sheet.
When the macro runs, it should search the word COLLECTION.
After the macro
Your method of looping is inefficient when compared to FIND.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dilan De Silva
Sent: Thursday, August 30, 2012 8:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to Calculate a total
-macros@googlegroups.com
Sent: Thu, August 30, 2012 10:17:10 AM
Subject: Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition
Your method of looping is inefficient when compared to FIND.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dilan De Silva
:37 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Macro to consolidate multiple sheets.
Hi Experts,
I have 5 excel workbooks each consisting of 3 sheets called: Climate Data,
Product Data Salary Details
All these 5 excel workbooks are stored in single
Dear Masters,
Please help me to with a macro which can send mail to recipient as mentioned in
different sheet.
For your reference I have attached a file containing 4 sheet. Sheet All
contains global data. Other 3 sheets covers sorted data with Vendor's name. In
each last 3 sheet, column X
Subject: $$Excel-Macros$$ Macro for mail from excel - with sheets as an
attachment
Dear Masters,
Please help me to with a macro which can send mail to recipient as mentioned in
different sheet.
For your reference I have attached a file containing 4 sheet. Sheet All
contains global data. Other
Hello All,
I found the following function from ozgrid
which reverses a text string
Option Explicit
Public Function ReverseString(Text As String)
ReverseString = StrReverse(Text)
End Function
I want a macro which should reverse a date entered eg 30062012 to 20120630
as soon as *data is
= 2012
If Right(Target, 4) = my Then _
Target = Right(Target, 4) Mid(Target, 3, 2) Left(Target, 2)
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Rashid Khan
Sent: Saturday, August 25, 2012 8:16 AM
To: excel-macros
Subject: $$Excel-Macros$$ Macro
:
*Subject:* $$Excel-Macros$$ Macro to convert date at the time of entry
Hello All,
I found the following function from ozgrid
which reverses a text string
Option Explicit
Public Function ReverseString(Text As String)
ReverseString = StrReverse(Text)
End Function
Send your file direct to ME
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: prkhan56
Sent: Saturday, August 25, 2012 1:46 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to convert date at the time of entry
Hello Don Sir,
I tried
*Subject:* Re: $$Excel-Macros$$ Macro to convert date at the time of entry
Hello Don Sir,
I tried the code
when I entered 30062012 - it changed to 12201632 instead of 20120630
I entered 08122012 it changed to 12208122 instead of 20121208
Can you please check
Thanks
On Saturday, August 25
-
From: pawel lupinski lupins...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Mon, August 13, 2012 7:36:01 PM
Subject: $$Excel-Macros$$ macro for detecting date in row
Hi All,
I'd like
Paul,
It's great this what I wanted
Thank you so so so so much
Pawel
From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com
Sent: Tuesday, August 14, 2012 12:22 PM
Subject: Re: $$Excel-Macros$$ macro for detecting date in row
Hi All,
I'd like to have a macro that will detect curent date (eg in column H)
then copy all all columns from A to column H (column H excuded so range
A:G) and paste all these column as value
Thanks
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
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
-
From: Amit Desai (MERU) amit.de...@merucabs.com
To: excel-macros@googlegroups.com
Sent: Fri, August 10, 2012 9:20:11 AM
Subject: $$Excel-Macros$$ Macro to sort excel data email to party
Dear All,
I need your expert help...
Please find attached sample file
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Friday, August 10, 2012 8:32 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to sort excel data email to party
So... you're wanting someone to do the whole thing?
Have you tried anything yourself
I am sorry Grp...
I take this request back.
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: 10 August 2012 19:20
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to sort excel data email to party
-
From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com
Sent: Fri, August 10, 2012 9:50:21 AM
Subject: Re: $$Excel-Macros$$ Macro to sort excel data email to party
Paul, For years this has been one of my “pet peeves” where an OP wants a free
project
-
From: dguillett1 dguille...@gmail.commailto:dguille...@gmail.com
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Sent: Fri, August 10, 2012 9:50:21 AM
Subject: Re: $$Excel-Macros$$ Macro to sort excel data email
Dear Paul,
Thanks for help. I will try this weekend..
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Paul Schreiner
Sent: 10 August 2012 20:10
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to sort excel data
Thanks for response, Ashish. This is very useful for me. But I have
another question. I need a macro which START counting from ZERO in
hh:mm:ss: format. When I stop the STOP Macro Button, The counting
also should have to stop.
Ex - If I Start Macro, The cell should have to start counting
Dear Experts,
I need a macro which started counting in any cell in hh:mm:ss format.
Also, another macro needs to stop that counting (stop time may be vary)
Thanks in advance.
Regards,
Dhananjay
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread
check the attachment see if it helps also visit for clocks
http://www.andypope.info/fun/clocks.htm
http://spreadsheetpage.com/index.php/file/analog_clock_chart/
http://excelunusual.com/archive/2010/12/making-a-clock-in-excel/
http://cpap.com.br/orlando/ExcelClockMore.asp?IdC=OMKtPlcG
Software
dguille...@gmail.com
*From:* CAN cdelano...@gmail.com
*Sent:* Tuesday, July 31, 2012 9:33 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Macro is not doing the right formatting -
need help
Thank you Don, you are correct. I should provide a more clear
It now works perfectly.
Many thanks Ashish !!!
On Wednesday, August 1, 2012 1:40:15 PM UTC-4, ashish wrote:
check the attachment see if it works
i have made few changes in this module only
*Private Sub SportExchangeQuery()*
On Wed, Aug 1, 2012 at 9:05 PM, Bill Q wrote:
Hi,
I have a simple excel sheet (attached file) The file is sorted by date
and it shows information about deposits made in a day. Sometimes a deposit
might have more than 1 transaction, sometimes it is just one transaction.
The data is as follows: Date, Unit ID, Amount Check number (there
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro is not doing the right formatting - need help
I have a simple excel sheet (attached file) The file is sorted by date and it
shows information about deposits made in a day. Sometimes a deposit might have
more than 1 transaction
Sent: Tuesday, July 31, 2012 9:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro is not doing the right formatting - need
help
Thank you Don, you are correct. I should provide a more clear explanation of
what I need.
I have attached 2 additional files that shows
check the attachment see if it helps
On Mon, Jul 23, 2012 at 9:29 PM, John A. Smith johnasmit...@gmail.comwrote:
Esteemed Excel Teachers - How would I go about creating a macro that would
open an Outlook draft and paste the highlighted range from my excel
spreadsheet into the body of the
in tools - reference - choose Microsoft outlook..
On Mon, Jul 23, 2012 at 9:57 PM, John A. Smith johnasmit...@gmail.comwrote:
Ashish,
Thank you for the quick reply. I get an error when I copy and paste your
macro in my spreadsheet. I attached a screen print of the error. A user
defined
That was it. I will go over this with a fine tuned comb and learn all I
can. Thank you most graciously for your much appreciated help.
John
On Mon, Jul 23, 2012 at 12:52 PM, ashish koul koul.ash...@gmail.com wrote:
in tools - reference - choose Microsoft outlook..
On Mon, Jul 23, 2012 at
-Macros$$ macro with multiple rows
Sorry All correct file
Hi All,
I'd like to ask you help me with writting macro, problem is I've no idea how to
do it?
In column M there are functions (colour in white) that need to be copied
accross rows (started from column O), but only these functions. When
,
Pawel
From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com
Sent: Saturday, July 14, 2012 5:24 PM
Subject: Re: $$Excel-Macros$$ macro with multiple rows
I do NOT understand your need. Give examples
if M___? is __then copy the VALUES
may be more appropriate.
Is this a project you want me to do for free or for hire?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Saturday, July 14, 2012 11:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ macro
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pawel lupinski
Sent: Saturday, July 14, 2012 9:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ macro with multiple rows
Hi DON,
so what I need is check if in eg cell M10
will be a book for VBA, but still not there. If can help me will be
great.
Regards,
Pawel
From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com
Sent: Saturday, July 14, 2012 7:42 PM
Subject: Re: $$Excel-Macros$$ macro with multiple rows
2012 19:02:25 +0100
*To: *excel-macros@googlegroups.com
*Subject: *$$Excel-Macros$$ Macro to populate Output file
Hello Everyone,
I would appreciate some assistance in creating a macro to export the
content in the file input to the file output. The spacing, tabs and
apostrophe should remain
Hello Everyone,
Kindly assist with a Macro.
Thanks.
Uzoma
Ojemeni Uzoma | Call 08060700717
-Original Message-
From: OJEMENI Uzoma uojem...@gmail.com
Date: Sun, 1 Jul 2012 19:02:25
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to populate Output file
Hello Everyone
Can you please explain with sample data.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ojemeni Uzoma
Sent: 02 July 2012 12:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro
...@gmail.com
*Date: *Sun, 1 Jul 2012 19:02:25 +0100
*To: *excel-macros@googlegroups.com
*Subject: *$$Excel-Macros$$ Macro to populate Output file
Hello Everyone,
I would appreciate some assistance in creating a macro to export the
content in the file input to the file output. The spacing, tabs
,
Kindly assist with a Macro.
Thanks.
Uzoma
Ojemeni Uzoma | Call 08060700717
--
*From: * OJEMENI Uzoma uojem...@gmail.com
*Date: *Sun, 1 Jul 2012 19:02:25 +0100
*To: *excel-macros@googlegroups.com
*Subject: *$$Excel-Macros$$ Macro to populate Output file
)/24*4),)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 30 June 2012 8:30
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Macro timings should be multiple based
.
** **
*Regards,*
*Lalit Mohan*
*www.excelfox.com/forum*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
*Sent:* Saturday, June 30, 2012 8:36 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: FW: $$Excel-Macros$$ Macro timings should
Hello Everyone,
I would appreciate some assistance in creating a macro to export the
content in the file input to the file output. The spacing, tabs and
apostrophe should remain the same way as it is in the output file.
Thank you everyone.
Ojemeni Uzoma
--
FORUM RULES (986+ members already
Hi Lokesh
You must apply [h]:mm:ss format on that cell to get proper result
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 30 June 2012 10:38
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Macro
@googlegroups.com'
*Subject:* RE: $$Excel-Macros$$ Macro timings should be multiple based on
date changing
** **
Use this One in G11:
** **
=D11+(((A12-A11)+1)/24*4)
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com
: $$Excel-Macros$$ Macro timings should be multiple based on
date changing
yes thank you, now the i have changed the date format.
And one more correction if there is no user timings and macro timings the
result should be shown blank not for 4:00:00.
please do the needful brother.
Regards
*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
*Sent:* 30 June 2012 8:30
*To:* excel-macros@googlegroups.com
*Subject:* Re: FW: $$Excel-Macros$$ Macro timings should be multiple
based on date
Hi All,
Please find the attached excel file, and i need total macro timings based
on date changes.
Let me know for any clarification.
Regards
Lokesh.M
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
@googlegroups.com
Subject: $$Excel-Macros$$ Macro timings should be multiple based on date
changing
Hi All,
Please find the attached excel file, and i need total macro timings based on
date changes.
Let me know for any clarification.
Regards
Lokesh.M
--
FORUM RULES (986+ members already BANNED
@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
*Sent:* Friday, June 29, 2012 7:18 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Macro timings should be multiple based on
date changing
** **
Hi All,
Please find the attached excel file
@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
*Sent:* Friday, June 29, 2012 7:18 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Macro timings should be multiple based on
date changing
** **
Hi All,
Please find the attached excel file
: $$Excel-Macros$$ Macro timings should be multiple based on date
changing
Hi All,
Please find the attached excel file, and i need total macro timings based
on date changes.
Let me know for any clarification.
Regards
Lokesh.M
--
FORUM RULES (986+ members already BANNED for violation
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Friday, June 29, 2012 7:18 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro timings should be multiple based on date
changing
Hi All,
Please find the attached excel file, and i need
Hi Richard,
Please explain what is child workbook..?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Richard
Sent: 25 June 2012 5:17
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros
Subject: $$Excel-Macros$$ Macro to copy a macro from one workbook to another
I would like to create a macro to copy a macro from one workbooks module area
to another workbooks ThisWorkbook area.
The first workbook is the master and any other workbook would be subsets of the
master. The idea
is child workbook..?
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Richard
*Sent:* 25 June 2012 5:17
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Macro
]
On Behalf Of Richard
Sent: 25 June 2012 8:57
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to copy a macro from one workbook to
another
A child workbook is a 2nd, 3rd or 4th workbook created from the master
with subsets of the data. The master may contain data for locations 1
I would like to create a macro to copy a macro from one workbooks module
area to another workbooks ThisWorkbook area.
The first workbook is the master and any other workbook would be subsets of
the master. The idea is to have a macro that will further lock cells from
input (sub
Dear Friends,
Does anyone have a macro to reduce column size all together?
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely
You mean column width?
Sam
On Sun, Jun 17, 2012 at 2:38 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Friends,
** **
Does anyone have a macro to reduce column size all together?
** **
Best Regards,
Amit
** **
--
Dear Amit,
May be I'm not sure whether you are familiar with this Or this is what you
are looking for i.e for making all columns adjust according to the Raw Data
in a sheet you do this Ctrl + A to select entire sheet and after this
Alt + O + C + A.
Hope this helps.
On Sun, Jun 17, 2012 at
use this macro
Sub gg()
Selection.ColumnWidth = 5
End Sub
you can change column width as per your need
On 6/17/12, Ahmed Honest ahmedhon...@gmail.com wrote:
Dear Amit,
May be I'm not sure whether you are familiar with this Or this is what you
are looking for i.e for making all columns
Thanks a lot for solutions..
Best Regards,
Amit
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ankur
Sent: 17 June 2012 16:10
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for column size reduction
use
Dear Ayush Noorian,
If the is a free e-book Can you please send me those e-books to my mail id:
prajakt.pa...@gmail.com
Thanks Regards,
Prajakt Pande
+971551388482
**
On Thu, May 31, 2012 at 6:55 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello everyone,
I hope the book which is being
Could you please send me that macro book too ?
On Fri, Jun 1, 2012 at 7:05 PM, Amol Jadhav asjad...@gmail.com wrote:
Hi Noorain sir,
Please send the ebook to my email id also...my email id is ---
asjad...@gmail.com, amol.jha...@originenergy.com.au
On 31 May 2012 14:59, NOORAIN ANSARI
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Thursday, May 31, 2012 9:55 AM
To: excel-macros@googlegroups.com
Cc: NOORAIN ANSARI
Subject: Re: $$Excel-Macros$$ MACRO
Hello everyone,
I hope the book which is being shared in this thread is free ebook
Excel
SalesAid Software
dguille...@gmail.com
*From:* Ayush Jain jainayus...@gmail.com
*Sent:* Thursday, May 31, 2012 9:55 AM
*To:* excel-macros@googlegroups.com
*Cc:* NOORAIN ANSARI noorain.ans...@gmail.com
*Subject:* Re: $$Excel-Macros$$ MACRO
Hello everyone,
I hope the book which
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Thursday, May 31, 2012 7:55 AM
To: excel-macros@googlegroups.com
Cc: NOORAIN ANSARI
Subject: Re: $$Excel-Macros$$ MACRO
Hello everyone,
I hope the book which is being shared in this thread is free ebook
Dear All,
I have send ebook on your email ID.
Please check and confirm me.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, May 31, 2012 at 10:21 AM, jmothilal gjmothi...@gmail.com wrote:
Sir , pls send me my email id jmothi...@yahoo.com
Sir ,
Please sir send the ebook to my email id also...my email id is ---
systemassistant2...@gmail.com
--
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
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 ,
Please sir send the ebook to my email id also...my email id is ---
systemassistant2...@gmail.com
--
FORUM RULES (986+ members already BANNED for
thanks sir.
--
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 answered.
2) Don't post a question
Dear Noorian,
Please send the 2007 file to jprakashp...@gmail.com.
Thanks in advance
Regards
Paul
--
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
Dear Noorian,
Can you please send me those ebooks to my mail id: talk2indra...@gmail.com
Thanks in advance.
On Thu, May 31, 2012 at 4:44 PM, Prakash Paul jprakashp...@gmail.comwrote:
Dear Noorian,
Please send the 2007 file to jprakashp...@gmail.com.
Thanks in advance
Regards
Paul
601 - 700 of 1194 matches
Mail list logo