Re: $$Excel-Macros$$ macros won't run as written

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

Re: $$Excel-Macros$$ macros won't run as written

On Fri, 1/12/18, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ macros won't run as written To: excel-macros@googlegroups.com Date: Friday, January 12, 2018, 4

Re: $$Excel-Macros$$ macros won't run as written

On Wed, 1/10/18, Paul Schreiner <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ macros won't run as written To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Wednesday, January 10, 2018,

Re: $$Excel-Macros$$ macros won't run as written

What does your macro look like? I recorded a macro, then "cleaned it up".the result being: Sub PageFormat     ActiveSheet.PageSetup.LeftFooter = ""     ActiveSheet.PageSetup.RightFooter = "" End Sub it seems to work great in Excel 2010 Paul- “Do all the good

$$Excel-Macros$$ macros won't run as written

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

Re: $$Excel-Macros$$ Macros for screenshot

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

$$Excel-Macros$$ Macros for screenshot

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

Re: $$Excel-Macros$$ Macros

"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

$$Excel-Macros$$ Macros

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

$$Excel-Macros$$ Macros get deleted

​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

Re: $$Excel-Macros$$ Macros get deleted

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 patil.rupesh1...@gmail.com wrote: ​Hello Experts I am using office 2013, when download any macro included workbook from this

$$Excel-Macros$$ Macros not Working Correctly

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

Re: $$Excel-Macros$$ Macros Tips

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

$$Excel-Macros$$ Macros Tips

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

Re: $$Excel-Macros$$ Macros Tips

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

Re: $$Excel-Macros$$ Macros Tips

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

Re: $$Excel-Macros$$ Macros Tips

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

Re: $$Excel-Macros$$ Macros Tips

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

Re: $$Excel-Macros$$ Macros Tips

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 chayamon...@gmail.com wrote: Dear Abhishek, Your tips are brilliant, thanks for sharing those clues. it

Re: $$Excel-Macros$$ Macros Tips

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 prabhupin...@gmail.comwrote: Hi Abhishek, the link

Re: $$Excel-Macros$$ Macros Tips

Very UsefulThanks to both of you. Regards Eugene On Fri, May 17, 2013 at 8:36 PM, Abhishek Jain abhishek@gmail.comwrote: 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,

Re: $$Excel-Macros$$ Macros Cartograms

Thank you so much On Mon, Jan 14, 2013 at 1:22 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: 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,

$$Excel-Macros$$ Macros Cartograms

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 @

Re: $$Excel-Macros$$ macros code help

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 vijayajith...@gmail.comwrote: Hi All, Set data = Activewkst.Range(Cells(1, 1), Cells(2, data_input_Last_col)) Here

Re: $$Excel-Macros$$ macros

send the file On Mon, Sep 12, 2011 at 5:49 PM, channa srinivas srinivascha...@yahoo.co.in 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?? --

Re: $$Excel-Macros$$ macros

Dear Srinivas, Please use below online vba password remover.. http://www.vbapasswordremover.org/ On Mon, Sep 12, 2011 at 5:49 PM, channa srinivas srinivascha...@yahoo.co.in wrote: hello everyone I have created a macro long back and i have protected it and now forgot the passwork, is it

$$Excel-Macros$$ macros

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

$$Excel-Macros$$ Macros needed to run on data change event BUT if there's na value na changes should happen

Hi Everybody, I need your smart help again. -- GOAL: I have data with different values and na spreaded on

RE: $$Excel-Macros$$ Macros needed to run on data change event BUT if there's na value na changes should happen

-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 na value na changes should

Re: RE: $$Excel-Macros$$ *** Macros required for Stock Reco***

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 against

Re: RE: RE: $$Excel-Macros$$ ***Macros Required to Simplify my work***

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. --

Re: $$Excel-Macros$$ ***Macros Code for rename active sheet***

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 prabhugate...@gmail.com wrote: Thanks Ashish, Regards, Prabhu --

$$Excel-Macros$$ ***Macros Code for rename active sheet***

Hi, Is it possible to rename the active sheet with current datemonth.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. --

Re: $$Excel-Macros$$ ***Macros Code for rename active sheet***

ActiveSheet.Name = Day(Now) - Application.WorksheetFunction.Text(Now, ) On Mon, Jul 11, 2011 at 5:22 PM, Prabhu prabhugate...@gmail.com wrote: Hi, Is it possible to rename the active sheet with current datemonth.Current date must be the date when i run the macro. Example if i run

Re: $$Excel-Macros$$ ***Macros Code for rename active sheet***

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 @

Re: $$Excel-Macros$$ ***Macros require to create Pivot Table***

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 --

RE: $$Excel-Macros$$ ***Macros require to create Pivot Table***

@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

Re: $$Excel-Macros$$ ***Macros require to create Pivot Table***

-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: $$Excel-Macros$$ ***Macros require to create Pivot Table*** ** ** Hi Ashish, ** ** Thanks, It is working

Re: $$Excel-Macros$$ ***Macros require to create Pivot Table***

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

RE: $$Excel-Macros$$ ***Macros require to create Pivot Table***

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

$$Excel-Macros$$ Macros to rearrange data

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

Re: $$Excel-Macros$$ Macros to rearrange data

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 chowderdra...@googlemail.com 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

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 manoj.bi...@gmail.com wrote: Hello All, Please can somebody advise me macros for paste special-transpose wherein i can just copy the data in horizontal format and

$$Excel-Macros$$ Macros for paste special-transpose

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

Re: $$Excel-Macros$$ Macros for paste special-transpose

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:=xlPasteValues,

Re: $$Excel-Macros$$ Macros for paste special-transpose

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 manoj.bi...@gmail.com wrote: Hello All, Please can somebody advise me

$$Excel-Macros$$ Macros in 2010

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 xls

$$Excel-Macros$$ Macros

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 --~--~-~--~~~---~--~~

$$Excel-Macros$$ Macros in Outlook

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

$$Excel-Macros$$ Macros connecting any software

Hi, Can anybody help me in creating a macro connecting Excel with any other software (except MS family) Mainframe, SAP Regards Karthik --~--~-~--~~~---~--~~ - Some important

$$Excel-Macros$$ macros and combo boxes

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