Search results for query: *

I'm in the process of converting to Excel 2007 from Excel 2003. I have buttons with assigned macros that manipulate data on other worksheets within the same workbook, then separate a worksheet into a new workbook. With Excel 2007, my buttons with the assigned macros don't remain static - I can...

I'm trying to rename a worksheet but keep getting a trailing quotation mark Sheets("YTD Budget Detail").Name = Sheets("YTD Budget Detail").Range("A7") & " Blossom"" " Gives me: Yellow Blossom" I'd like it to read: Yellow Blossom

I might be exposing myself a bit here, but here it goes. Many thanks in advance. This request might seem a little strange, but there is a method to my madness. I have a list.. I'd like a macro to scan down the 1st column (Color) and add two rows after every change in color So this: Color...

Example (Using Excel 2003) Sheet1 - Table1, variable rows Sheet2 - Table2, same format, variable rows. I want to copy Table2 directly underneat Table 1 so it is one big table (basically merge the tables) Here's my code - less the missing piece Sub CopyTable() ' ' CopyTable Macro ' ' Go to...

I have a button assigned to a macro in Sheet1, WorkbookA. When I copy Sheet1 to a new workbook (WorkbookB), the button wants to use the macro in WorkbookA. Because I put the macro in Sheet1, there is a version still there (in WorkbookB) but the button ignores it as it is still assigned to the...

I have a list in excel. I'd like to automatically hide the rows that return "N/A#" in column C from row 2 to 40. The following code is close.. it does it if the values of column C are zero. Note: I do not want to get rid of the formulas in row C and I do not want to use the filter...

I've validated a cell with a list of choices. Is there anyway to make it so the drop down menu is permanently visible, instead of visible only when clicking on the cell? Thanks in advance

My macro creates a worksheet from other data in Excel. When it prints, I'd like it to go the length of the list of subtotaled data, but it keeps going for many blank pages. Any easy code fix? My printing code I put in is as follows: With ActiveSheet.PageSetup .LeftHeader = ""...

I just had my computer upgraded at work, and I think it's related to this problem. When I try to import a table into Access from Excel or Text file, I get an import Wizard error message "There is no object in this control" and can't continue to import. Anybody know how to fix this?

I'm running the following, and cell A2 has no data, it's blank, and I'd like the message to pop up, but it's not happening. Any ideas? ' Validate that data is available Sheets("AABS").Select If IsEmpty(Range("A2").Select) Then MsgBox "The combination you have chosen returns no...

I posted this in the Office Forum also... don't know exactly where it belongs. Sorry to double up. I have a workbook that does the following: I press a button and a macro (let's call it macro 1) runs manipulates a worksheet (Sheet3) and then moves it to it's own separate workbook. When it's...

I have a workbook that does the following: I press a button and a macro (let's call it macro 1) runs manipulates a worksheet (Sheet3) and then moves it to it's own separate workbook. When it's all said and done, Sheet3 has become Sheet8. Sheet3 has a macro saved directly to it (let's call...

I have some macros that play with the page breaks and column groupings. They are associated with some radial buttons on a worksheet. I can move that worksheet out of the workbook but the macros are then lost. Any easy fix for this?

I have some macros that play with the page breaks and column grouping associated with some radial buttons on a worksheet. I'd can move that worksheet out of the workbook but the macros are then lost. Any easy fix for this?

Example. From A1 to A100 there are a series of cells with various colors. I'd like to sum only the red cells. Thanks.

I have a file with two worksheets, "Sheet1" and "Sheet2". To solve my problem here's a simplified example. Sheet1 looks like this: Column A Column B Column C Blue 1 100 Blue 2 100 Red 1 100 Blue 1...

I have two sheets, Sheet1 and Sheet2 I'm in cell A1 In cell A2 I have a number, for example "22" In cell A1 I'd like to reference a cell on Sheet2 in the 22nd row, column A. Obviously if this was a text exercise, I would type in A1 "=Sheet2!D22" However, I have a few thousand of these to...

using the name of a specific cell as the name of the file I want to save. For example. Cell A1 has the text "Apple". The macro should save the file as "Apple" in the My Documents folder. Thanks in advance.

I don't thing Vlookup or SumIf will work. Here's the example. Tab 1 Column A Column B Column C Color A or B Amount Red A $100 Red A 200 Red B 50 Blue A 60 Blue A 40 Blue B...

Quick dumb question. I've blown right past this in my VBA for Excel "self education" because usually the Subtotal function works for what I need. However, in this case I don't want to use it. My macro should generate a sum of all the numbers in column F in the blank cell at the end of column...