hide rows

I found this code on one of the Mr. Excel threads and it is really close to what I am looking for, I think: I have a table setup called SCTable that contains many fields. I am using this table for generating a graph. The problem is that it contains some blank rows and I would like the blank...

I am somewhat a novice with VBA, in other words, I am still learning. I am trying to write a vba macro that would hide columns based on what is presented in another table. This will allow me to update the table and not have to worry about updating the macro on a continuing basis. For...

I have two forms. One form has all the userform pop ups asking for details of expenses made (Expense Report P-1) Another form has all the details listed so it can be printed out (Expense Report P-2) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...

Dear All: I need to hide all of the rows in a spreadsheet (15,000 rows) that have a part number that does not start with M or K. I have found lots of simple macros that do something similar but usually not with any sort of textual evaluation. Any help please?

Hello Everyone, I have Worksheet 1(TB) that is a trial balance; Column A, Column B, Column C (Account #), Column D (Account Desc.), and Column E (Account Value). This is created using an import of a csv file and has +/- values in Column E. Worksheet 2 (Groupings) has 3 Columns; A (Account...

Hello, I am a beginner user of VBA and am having trouble finding a function to do what I need. I have a predefined range in excel (about 1000 cells) called Range 1. In this range I have the values "user" and "visitor". When a checkbox (chk1) is checked, I want a code to search Range 1 for the...

Hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have this macro that hides rows when the value is “0”. <o:p></o:p> At the moment it’s not running very smoothly and updating quickly, i.e the Application.Sreenupdating isn’t working correctly...

Hello I want to hide rows with empty data in a column (D) but only in a specific part(range A11:D39) of the worksheet before printing. I though that following part of code could do the job but I'm wrong With ActiveSheet On Error Resume Next Set rng =...

Some of today's earlier posts discussed this, but I wasn't able to apply them successfully to my issue. I have an area for comments in a sheet titled "Arbitration" (list in cells AB2:AB15--cell 2 merged with 3, 4 with 5...14 with 15). On another sheet titled "T.O.C." I have cells C6:C12...

Hi, I'd like to create a Macro in Excel 2007 that will hide each row that has a certain entry in a certain column, and keep all other rows visible, whether the rows started out hidden or not. Can you help? Thanks!

Hello, I have a problem with a VB routine that resets cells to zero. I am an experienced user in Excel (2007, Windows XP) but a novice in VBA. I have spent many hours researching and trying to solve my error on my own and would greatly appreciate any suggestions. I have a financial...

Dear all, On "Sheet2", there is data unsorted. Every row is a sales lead, entered by an employee. There are of course multiple leads per employee. This sheet is supposed to be hidden/protected. The name of the employee is in row E. On "Sheet1", I want a cell (or listbox, whatever works...

Hello, I am trying to construct a macro to hide a row if its Column E cell has a) a value greater than 14, or b) an error (specifically a #num! error). The spreadsheet I am working on is a list of birthdays. Columns A and B contain names; column C contains the mm/dd/yyyy birthdate; column D...

Hi Everybody I seem to have a simple problem but can't get it right. I am trying to hide Rows with multiple ranges. I recorded this to see how to structure such a statement. Range("7:12,22:28").EntireRow.Hidden = True This works obviously however the following doesn't and I don't understand...

I have a simple macro to hide rows, below what i need is a macro that will hide/unhide a set number of rows below the row where the macro is acivated. i have a list of names approx 100, each with 11 rows of data below them, i want the data below each name to be hidden until the macro is...

I have a spreadsheet with content IDs in the first column. I want to analyze the rows with duplicate (not unique) content IDs. The other columns are not the same so the rows are not exact duplicates. I need a formula or macro that will hide or delete the rows with unique, non-duplicate...

Looking for some help hidding rows. I have a data set that is variable in size but no larger than 3000 rows. I would like to write some VB code that based on a value in column A (which is already sorted by Yes then NO) finds the first row with a value of "No" and hides that row and all rows...