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
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
"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,
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
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
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,
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??
>
>
>
> --
>
> ---
Try this Code:
Option Compare Text
Public val As Variant
Private Sub Worksheet_Change(ByVal Target As Range)
If val <> "na" Then
Target.Interior.ColorIndex = 6
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo Err:
val = Target.Value
Err:
End Sub
-Ori
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
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
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
35 matches
Mail list logo
