macro help

Hi- help would be greatly appreciated on a macro to clear cells with numbers but no cells with formulas with in this macro: Dim i As Long i = Range("E3") If i > 0 Then ' Copy range Range(Cells(6, 10 + i), Cells(500, 17)).Copy Range(Cells(6, 10), Cells(500...

I need help copying data from 5 separate worksheets to my summary worksheet underneath the matching column headers.The data copies over but it disappears from all of the columns except the 1st one. I need some help with this one. I know it's a simple fix but I'm missing the logic. Thanks Sub...

Hi all, I need to clean up this code that I recorded from the Macro Recorder. I need it to basically delete the words "Slide" and the number associated with it. So depending on the file, I might have Slide 1, Slide 2, Slide 3, or I could have Slide 50, Slide 51 etc. I realized when I run the...

Right now I have a code that is working great (Which I got from this site) :) I need help to modify it to do something else. I have a button that cycles through my validation list and creates PDF file for each value on the validation list. My validation list is short for this post...

<TABLE style="WIDTH: 317pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=423><COLGROUP><COL style="WIDTH: 317pt; mso-width-source: userset; mso-width-alt: 15469" width=423><TBODY><TR style="HEIGHT: 217.5pt" height=290><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT...

Hello Forum, I found this searching threads and it works too well! I want this macro to only work in selected cells, not the whole document. Sub ReplaceCRLF() ActiveCell.Replace Chr(13), " ", xlPart 'x1Part apply to within cells (default) ActiveCell.Replace Chr(10) & Chr(10) &...

This is a Macro that has taken me weeks of research to write, mainly because I have had no experience with Macro before and finding the information on how to write the different codes took alot of research so I am sharing this Macro on here so that anyone struggling with any part of their macro...

OK, this is something I have to do over and over everyday so I need help building a macro for this process. This is an example of what the sheet has: A1 = 1 (a number from 1 - 5, represents a text file) B1 = John Doe (Name) B2 = John Doe Question 1 B3 = John Doe Answer 1 This will be one...

Hi, I'm new to using macros and VBA in excel. I am trying to store data in another worksheet but it does not automatically move to the next column. I want to store incrementally to the right of the last column with data on the second sheet. my macro code below as follows: === Sub Macro6() '...

hi all am having trouble with excel macroing i have got 2 sheets on my file one is a form which i fill in i then have a macro that copys the important data and saves it to the other sheet in a table form problem is i cant get the macro to jump to the next line after copying, so i keep...

Hello I have a macro that opens another workbook and deletes rows based on specified criteria. The code that deletes the rows works fine but runs extremely slow. When I step through it my self it seems to work relatively quick but it gets caught up when its running. Here is the sub program...

The code below is part of a much larger macro, but its the most crucial bit. For the macro to work the user must have already imported a datasheet which contains the word 'Timestamp'. If the user hasn't imported the file, he gets a standard error message Run-time error '91': Object variable...

Excel 03 I have a templet workorder that I copy and use every day. In cell "e6" I have the formula =today() so it puts todays date in all my new workorders I make. (laugh now) :rofl: You all know whats happening and I didnt catch it until today. YES, Every time I open my workbook all my sheets...

I have been working on a workbook for workorders. I got it all set up but have thought about something that would save me a great amount of time. I have a macro that makes a copy of my main workorder when clicked but the name of the new sheet is workorder (2), workorder (3) ect. . I would like...

I have a macro that will find a sheet in my workbook. It works great the first time it runs , If I put in a name of a sheet that is not in my workbook it sayes "no record found for (fName) try again" I hit try again and it works but if it doesent find the sheet name the second time I get a Run...

Hi I am trying to write a macro to run the following macros: Sub Macro17() Sub Macro19() Sub Macro21() Sub Macro22() Sub Macro24() Sub Macro29() Then be taken to cell B11 Does anyone have any idea how to do this? I tried recording it but it didn't work. Thanks!

Hi, I have this macro which hides rows based on the results in other cells. All works fine, had to add Application.ScreenUpdating = False/ and True to stop the page flickering each time a validation box was selected BUT then i went to complete the project by protecting the sheets and two...

I have a shared work sheet, where everyone in the team may update information in sheet1, saved and closes it. I want a macro or something that will keep track of who updated the information 1. User domien name 2. Time log in and out from worksheet This may be way too difficult or easy...i...

:confused: Great People...! Pease design this macro for me... When the Sheet1, A1 = now() (value - 6/5/2010 12:00:00 AM) Can you please make a pop up to come up. Chris's - birthday! So the thing is i want the macro to trigger when now() = time and date mentioned above , I want the macro to...

I made the macro below, closed the recording, but when I place my cursor on the button instead of the cursor finger waiting for my enter command, the four arrow (up-down, left-right) remains waiting for an edit. What can I do to correct this? Sub Delete() ' ' Delete Macro ' Macro recorded...