hidden rows

hi guys, first of all I am new in VBA! i have this worksheet as an example <tbody> A B C D E F G 1 person goods price % $ paid countif! 1/countif 2 X A 100 30% =D2*C2 =COUNTIF(B:B,B2:B2) =1/F2 3 Y A 100 20% =D3*C3 =COUNTIF(B:B,B3:B3) =1/F3 4 Z A 100 10% =D4*C4 =COUNTIF(B:B,B4:B4)...

I am looking to have excel essentially unhide a row based off of a selection in a drop down box. The drop down box has multiple selections available and wanted to expose the proper row based on the drop down selection. Is this possible or does it need to be VBA? Thanks!

Hi, I would like to have a list with values in range H:H, but only the rows that are visible (not hidden). Is that possible?

I have the following code which should find the longest string in an array. I want to modify it to exclude hidden rows, however. Any ideas on how I might do this? Dim cell As Range Dim strLongestCellRef As String Dim intLongestCellLen As Integer For Each cell In Sheets("Sheet1").Range("B6:B45")...

Hello, I'm using the following formula in Excel 2010. =INDIRECT(ADDRESS(ROW()-1,COLUMN()))+(CONCATENATE(0.01)) What I would like to do, is to convert this formula to reference the first unhidden row above. Currently, it will just reference the row above weather it is hidden or not. I would...

Excel 2007 I know how to set up If Thens based on cell value, but can I set one up that will run depending on whether or not a particular row is hidden instead? Thanks in advance for any help :)

Hi All: I know the checkboxes are all there, they are just not visible any more. The code below worked for a while then stopped. It hides (and unhides the rows), but doesn't allow me to see the checkboxes when the rows that the checkboxes are floating on top of are unhidden. I would appreciate...

Hi, What I am trying to do is select a column and filtering for blanks. I want to offset down one - but when I use the below code it doesnt ignore the filtered rows. ActiveCell.Offset(1,0).SelectI need the code to ignore all filtered cells and select the first empty cell. Thanks in advance...

Hi, I think I'm just being dumb but I'm trying to calculate a value based on the row above eg. A1... 100 =100 A2... =A1+1 =101 A3... =A2+1 =102 etc However, I don't want to include hidden rows but if I hide row A2, A3 still reports 102 as the answer. How do I make the formula dynamic...

On 'Sheet1' I have multiple rows of data. I autofilter on Column 'A' and only display a single employee ID number. This results in only rows 15, 37, and 197 being displayed. On 'Sheet2' I want to enter a formula in cell 'A1' that pulls a specific range of the displayed (not hidden) rows in...

Ok, I have searched the forum, tried using Excel Help but just can't quite figure it out. What I have created is a project management timeline spreadsheet. what i want to do is use a toggle button to hide and unhide any rows that do not contain any information in column A. sometimes not all...

I have a worksheet I use for conferences to estimate travel costs for attendees. On the first worksheet I have a list of all attendees and based on what type of employee they are, it populates different worksheets in the workbook. There is a possible 400 attendees but i need the worksheets to...

I have a value in a hidden row that I now want to edit. I protected the workbook structure and the worksheet. No I find that even if I unprotect the workbook and the worksheet, I can't unhide the row! Can anyone tell me what is going on here?

I have created a workbook that I need a macro for In sheet one I have inserted a "push button" that I'm assigning a macro to in sheet 3 All calculations and fields are already completed at this point. What I need is the system to jump to sheet 3 and hide all the rows that have a "No" value in...

Hi everyone, I'm new to the forum and I'm really counting on your help. The problem I'm struggling with in excel is that I would like to create some kind of a filter or a drop down list for selected number of rows, which could only be made visible by entering a password. So selected rows...

I am creating a button in excel to hide any rows that are missing data in the first column. I've got the code worked out I believe, but I can't make the button work. The code is as followed: Sub Button74_Click() For Each r In Range("A10:A164") If r.Value = "True" Then...

Hello. In my sheet activate code, I have a series of rows hidden, as shown below. Private Sub Worksheet_Activate() Range("16:364").Select Selection.EntireRow.Hidden = True 'Hides everything when the sheet opens End Sub I have check box controls that if a user clicks in a specific check box...

Hi, I'm trying to accomplish this in VBA. I have a sheet where many rows are hidden. Through VBA, I need to iterate through the rows that are visible only. Is there a way to do this? Cross-posted at excelforum.com

A client of mine has a workbook in Excel 2007 (although it may be descended from an earlier version of Excel.) When she prints the workbook, hidden rows are printing along with rows that are not hidden. The rows in question do not appear in Print Preview but they do appear on the hard copy. Any...

I have an Excel spreadsheet with numerous hidden rows. I find that under normal circumstances with non-merged cells, when I press enter Excel will move down to the cell in the next visible row. It works great. However, I recently discovered that under some circumstances this is not the...