Search results for query: *

Maybe this is a question for the Office forum. The code (your or mine), works fine the first time it's run. When I go back to my original workbook, there is a button where macro is assigned. Instead of pointing to Macro7, it points to Book27!Macro7. Excel 2003 didn't have this...

Hi Skip, Here's sample code: Sub Macro7() ' ' Macro7 Macro ' ' Sheets("Sheet2").Select ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Add Key:=Range("A2:A50") _ , SortOn:=xlSortOnValues, Order:=xlAscending...

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 am retarded. This works. For posterity: Sheets("YTD Budget Detail").Name = Sheets("YTD Budget Detail").Range("A7") & " Blossom

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

Sorry, that wasn't what I needed. I see exactly where you're going with it, and understand, but there are just some issues on my end that I can't shortcut. That being said, I did some research, and a version of this worked. I appreciate the try though Skip. You've solved a bunch of issues for...

Well... here's my problem.... my real spreadsheet contains a couple more columns and a total. Here's the redo. Client Location Year Hours Jan Feb March etc. Barneys California 2009 10 Barneys California 2010 9 Barneys New York 2009 8 Barneys New York 2010 7...

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

Skip, Worked like a charm. If I might be so bold as to ask... you have short version of why you dislike the Select and Activate method? Does it tend to get a little buggy compared to your method depending on the lists in question?

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

Figured it out. CommandButtons are my friend.

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

BINGO! Thanks Skip. That DOES work. Nice and easy.

Some of us live in the real world Skip, where co-workers and wants and needs.

Hi PHV, Hm, interesting code, but it doesn't actually hide any rows. :-)

Hi Skip, It's a great report! :-) If I can get it to work. Each table is one below the other. If it was just one report I wouldn't want a macro, but my workbook has 90+ clients (one client per worksheet, with charts, etc). Each client returns a unique number of rows. My solution is to set...

Hi Cloak, The issue isn't how to hide the rows, the issue is getting the code to recognize the N/A cells that the formula returns. My example uses zeros and integers. I'm trying to get it to recognize formula values and N/A! results. Thanks for the tip, though.

Hi Skip, Thanks for the help, great idea on the row hiding, but I've run into another roadblock. Using auto filter doesn't work because in my worksheet I have to filter two different tables on the same worksheet which Excel doesn't allow. My original question/example was extremely...

Hi Skip, I don't want the AutoFilter arrows to show up on the workbook.

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