Thanks Paul! This did work to put the footers in. I even figured out how
to add a few more things. Really appreciate your help!
Kelly Ann
On Wednesday, January 10, 2018 at 1:08:57 PM UTC-6, Paul Schreiner wrote:
>
> What does your macro look like?
>
> I recorded a macro, then "cleaned it up"
On Fri, 1/12/18, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ macros won't run as written
To: excel-macros@googlegroups.com
Date: Friday, January 12
On Wed, 1/10/18, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ macros won't run as written
To: "excel-macros@googlegroups.com"
Date: Wednesday, January 10, 2018, 10:08 PM
What
does your macro look like?
I
recorde
What does your macro look like?
I recorded a macro, then "cleaned it up".the result being:
Sub PageFormat
ActiveSheet.PageSetup.LeftFooter = "&D"
ActiveSheet.PageSetup.RightFooter = "&Z&F" End Sub
it seems to work great in Excel 2010
Paul-
“Do all the
I have a very basic macro to do a page set up format. Even though it looks
right in VBA it doesn't do what it is set up to do. I set up the following:
Page - Fit 1 to 1 and Landscape - this part works
Margins settings - this part also works
Header/Footer - Put [&(Date] in the Left section and &{
use
ActiveSheet.Paste
to paste the content from excel clipboard.
Regards
Eugene
On Thu, Mar 23, 2017 at 1:43 PM, suresh k wrote:
> Hi All,
>
> I have 10 files in my c drive. I have to capture other applications
> screenshot and paste in all 10 files.
>
> I am able to capture screenshot, but n
Hi All,
I have 10 files in my c drive. I have to capture other applications
screenshot and paste in all 10 files.
I am able to capture screenshot, but not able to paste in 10 excel file.
Please suggest macro to paste screenshot in all files
Regards,
Suresh
--
Are you =EXP(E:RT) or =NOT(EXP(E:
"Is there a macro that can do this"? No"Can a macro be written to do this"? Yes
What I would do:
I see three files:Macro FileInput FileOutput File
The macro Initializes an Output worksheet, then reads in the data from the
Input file and writes it to the Output sheet (with the updated pricing)Then,
Hi
We get an excel spreadsheet from our suppliers with products and prices.
Currently we add a column where we add a percentage to their prices which
we use as our selling price. We then delete our suppliers price and then
email out to our customers. Is there a macro etc that can do this for us
Dear Rupesh,
Have u open it with Enable Macro?
and also save it as it Macro Enable file...
Regards,
Prafull Jadhav
9920553518
On 8 September 2014 12:40, Rupesh Patil wrote:
>
> Hello Experts
> I am using office 2013, when download any macro included workbook from
> this group macro get delete
Hello Experts
I am using office 2013, when download any macro included workbook from this
group macro get deleted when open this workbook. could any one why this
happen.
Thanks in advance
--
Thanks & Regards,
Rupesh Patil,
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
I have a workbook which has thousands macro (user functions) on one
worksheet for data analysis. Sometimes, the macros returned a "#Value". I
tried Recalculate which has no impact. I can only make it work when I
closed the workbook and reopen it again. But, once I change a value and
do the
Dear Abhishek
Its really helpful (site and the draft)
You said it rightly here are many Excel master who are ready to help for
all your problem and as per my experience you will get more than one
solutiion for any problem
Once again thanks for site and draft
Dear Chhaya
I am not expert in Macro but
Very UsefulThanks to both of you.
Regards
Eugene
On Fri, May 17, 2013 at 8:36 PM, Abhishek Jain wrote:
> The link was shared with me by Priti. She is an active learner and finds
> such stuff.
>
> Priti - please share more links like this, if you have.
>
> Regards,
>
> Abhishek
>
>
> On Fri,
The link was shared with me by Priti. She is an active learner and finds
such stuff.
Priti - please share more links like this, if you have.
Regards,
Abhishek
On Fri, May 17, 2013 at 7:26 PM, Prabhu Pinky wrote:
> Hi Abhishek,
>
> the link "http://www.excel-pratique.com/en/index.php"; you give
Hi Abhishek,
the link "http://www.excel-pratique.com/en/index.php"; you given is really
useful.
Please suggest more link like this...
Regards,
Prabhu R
On 17 May 2013 17:43, Chaya wrote:
> Dear Abhishek,
>
> Your tips are brilliant, thanks for sharing those clues. it will be a
> great
Dear Abhishek,
Your tips are brilliant, thanks for sharing those clues. it will be a
great inspiring, rhythm of elevation towards preparing self thorough in
aspect of macros. The cited *link* above is a great aspiration for a macros
beginners.
thanks for sharing and bringing back the life
Firstly, take a breath. Keep calm. Just because you're reading e-books,
googling for 2 months and you don't know how to use 'Dim'...doesn't mean
you should be ashamed. Humans are strange. They went to moon before
figuring out that it would be handy to install little wheels in luggage. My
point is -
Thanks David sir,
yes you are right. self practice is the best platform for learning
initial steps. thanks for the advice. and henceforth i will keep learning
with the culture. but of all this, i think there should be a guidance which
helps in learning by understanding the concepts.i mean there
Two major things will help you. One is the help files which are invoked
whenever you click on a word in a macro and then press F1. I am sure you
have found that, but do you use it whenever you do not understand all about
a keyword such as Dim?
The other thing is intellisense. When you are typin
Dear experts and all,
I am trying to learn excel macros from initial steps. please provide
some advance tips to learn the source from initial. Actually, i am learning
by recording the macros and trying to get the logic, but it does not make
me fullfil to learn. even i reading ebooks and tryi
Thank you so much
On Mon, Jan 14, 2013 at 1:22 PM, Anoop K Sharma wrote:
> Hi Jai,
>
> Please find attached file. Look at sheet2, select the country name from
> combo box at upper left corner, use spin button to change the size of shape.
>
> Regards,
> Anoop
>
>
> On Thu, Jan 10, 2013 at 3:57 PM,
Hi Team,
I need to write a macro on the attached template Cartogram where I can
adjust a value and the size of countries in a map of the world changes (but
their vague position stays the same)...
Thanks a ton for the help!
Sri
--
Join official Facebook page of this forum @
https://www.faceb
Dear Vijay,
Try it
Range("A1").Select
Set Data = Range(Selection, Selection.End(xlToRight))
Data.Select
See attached sheet..
On Mon, Jul 9, 2012 at 10:19 PM, vijayajith VA wrote:
> Hi All,
>
> Set data = Activewkst.Range(Cells(1, 1), Cells(2, data_input_Last_col))
>
>
> Here *data_Input_last_
Dear Srinivas,
Please use below online vba password remover..
http://www.vbapasswordremover.org/
On Mon, Sep 12, 2011 at 5:49 PM, channa srinivas wrote:
> hello everyone
>
>
> I have created a macro long back and i have protected it
> and now forgot the passwork,
> is it possible to veiw the
send the file
On Mon, Sep 12, 2011 at 5:49 PM, channa srinivas wrote:
> hello everyone
>
>
> I have created a macro long back and i have protected it
> and now forgot the passwork,
> is it possible to veiw the code??
>
>
>
> --
>
> ---
hello everyone
I have created a macro long back and i have protected it
and now forgot the passwork,
is it possible to veiw the code??
--
--
Some important links for excel users:
1. Follow us on TWITTER for ti
lue
Err:
End Sub
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Guzal Yusupova
Sent: Thursday, August 18, 2011 11:53 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Macros needed to run on data change event BUT if
there's
Hi Everybody,
I need your smart help again.
--
GOAL:
I have data with different values and "na" spreaded on she
Hi Rajan,
In Report sheet "C" column "Purchases" has to taken from purchases sheet
against particular part number mentioned in the column "A" and total qty
purchased.It may me more then one line items.
Similarly Closing stock and Sales also we have to take total cl stock and
total sales again
Hi Rajan,
Good, It is working fine.
A small request, Sell in and sell thru value must be in 2 decimal place with
"1000'separator(,) in base and other two sheets.
Kindly help to amend the same.
regards.
Prabhu.
--
--
Dear friends,
you can use this code as well
ActiveSheet.Name = Application.WorksheetFunction.Text(Now, "dd-")
regards
Sudheer
(sudheer...@gmail.com
On Mon, Jul 11, 2011 at 7:21 PM, Prabhu wrote:
> Thanks Ashish,
>
> Regards,
>
> Prabhu
>
> --
>
> ---
Thanks Ashish,
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/g
ActiveSheet.Name = Day(Now) & "-" & Application.WorksheetFunction.Text(Now,
"")
On Mon, Jul 11, 2011 at 5:22 PM, Prabhu wrote:
> Hi,
>
> Is it possible to rename the active sheet with current date&month.Current
> date must be the date when i run the macro.
>
> Example if i run the macro on
Hi,
Is it possible to rename the active sheet with current date&month.Current
date must be the date when i run the macro.
Example if i run the macro on 11th of July, Sheet name has to be "11-July"
Thanks,
Prabhu.
--
-
Great Ashish,
*You are the master of your own destiny!!!*
**
*Thanks*
**
*Prabhu*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2
**
>
> ** **
>
> ~S
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Prabhu
> *Sent:* Saturday, July 09, 2011 10:06 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re:
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu
Sent: Saturday, July 09, 2011 10:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ ***Macros require to create Pivot Table***
Hi Ashish,
Thanks, It is working prefect!
A small request, It is working
Hi Ashish,
Thanks, It is working prefect!
A small request, It is working only the data sheet name is "BASE"
Can you help me if the name of the sheet is different, then how to use this
macro. Because same workbook am adding the data on daily basis.
Kindly do the needful.
Regards,
Prabhu
--
See if it helps
http://excelpoweruser.blogspot.com/2011/07/creating-pivot-table.html
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu
Sent: Friday, July 08, 2011 6:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ ***Macros require
can you attach the sample workbook and showing the format in which data
needs to be pasted
On Tue, Jun 14, 2011 at 7:56 PM, CIISA wrote:
> Dear all,
>
> I'm really hoping you can help me or at least answer a question that I
> have regarding macros and how clever they can really be.
>
> Take a
Dear all,
I'm really hoping you can help me or at least answer a question that I
have regarding macros and how clever they can really be.
Take a look at the sample data below (an imagine it in an excel
worksheet):
Person ID LearnerCourse title
Date Duration (hrs
cros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macros for paste special-transpose
copy the data area and use paste special -transpose it u wil get the
required r/shiva
On Tue, Jan 25, 2011 at 8:42 AM, Manoj b wrote:
Hello All,
Please can somebody advise me macros for paste spe
copy the data area and use paste special -transpose it u wil get the
required
r/shiva
On Tue, Jan 25, 2011 at 8:42 AM, Manoj b wrote:
> Hello All,
>
> Please can somebody advise me macros for paste special-transpose wherein i
> can just copy the data in horizontal format and paste them in vertica
Sub Bang()
Dim Rng As Range
Set Rng = Cells(1).CurrentRegion
Rng.Copy
Rng(1).Offset(Rng.Rows.Count + 2, 0).PasteSpecial _
Paste:=xlPasteAll, Transpose:=True
End Sub
On Tue, Jan 25, 2011 at 10:12 AM, Manoj b wrote:
> Hello All,
>
> Please can somebody advise me macros for paste special
try this...
Sub Transpose()
'
' Macro Transpose
'
'
Range("A1").Select
Selection.CurrentRegion.Select
Selection.Copy
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Range("G1").Select
Selection.PasteSpecial Paste:=xlPasteValu
Hello All,
Please can somebody advise me macros for paste special-transpose wherein i
can just copy the data in horizontal format and paste them in vertical with
a shortcut key.
My data looks something like below in different sheets of same workbook
2009 2008 2007
1.2 0.84 0
The following code fails in excel 2010 and it worked fine in 2007
Sheets("Report").Select
[Meeting_Date].Select
I get the error messages "Compile Error can't find project or library"
In the names manager: Meeting_Date refers to:=Report!$N$8 with
the scope workbook.
the file is an
Hiii ... I want to learn the macro functions, so if u have any files
regarding basics of macro then plz mail to me.
Thanks in Avance
Regards
vebhav jain
--~--~-~--~~~---~--~~
-
Hi
I have to send a same mail frequently to all the employee.so i need to some
macros where as i run the macro,the content to automatically apear in new mail
Thanks and Regards
Shashank Bhosle
Life is all about Uncertaity
Unlimited freedom, unlimited storage. Get it now, on
http
Hi,
Can anybody help me in creating a macro connecting Excel with any
other software (except MS family) Mainframe, SAP
Regards
Karthik
--~--~-~--~~~---~--~~
-
Some important li
Following is an excel sheet which contains data abt shares I want to follow.
I want to get an email to my id once the actual market price reaches a value in
the range of Expected mkt price. Is this possible?
Thanks & Regards,
| Shreyas Shringarpure | Team Lead (BA)- DTM | Target Corporation Indi
I would like to have a combo list box that has every day of the week
in it. When i select different calendar days, i want my data set to
add up the values of a 7 day period from saturday thru sunday based on
the weekday that falls on the first day of the month chosen. for
example if i had a data s
53 matches
Mail list logo
