visible

How do I count visible (filtered) cells in 2 columns (data range below) with values between 1.5 & 2. Meaning if cell value is equal to or between 1.5 & 2 it counts. I have figured out how to do this with unfiltered data but cant seem to figure it out with filtered data, HELP PLEASE...

Is there a way to see when some legend items are not displayed? My dynamic chart has a legend with dynamic area size. So depending on amount of series and the legend are, some legend entries may not be shown (no space for them). I just want to add a warning to my user in such a case. I have...

When I try to print only the visible cells after filtering,it prints one row per page, instead of all on one page. If there is no filter on it prints correctlyall on one page. This is my code: FinalRow = Cells(Rows.Count, 3).End(xlUp).Row ActiveSheet.PageSetup.PrintArea = Range("C7:M" &...

I am trying to count visible cells only between 1.5 & 2. I used this formula: =COUNTIF(J7:J83952,">=1.5")-COUNTIF(J7:J83952,">2") But how do it get this to work with filtered data? Also, is there a way to add another column of data to search (N7:N83952)

Hi all. I hope you can help me as I am having a bad, bad day I was editing a long macro earlier in VB editor and when I returned to it, my macros have all disappeared. The PERSONAL.XLSB file is still visible in C:\Users\tt*******\AppData\Roaming\Microsoft\Excel\XLSTART which I hope is a...

Hello all, this is my first post as i've recently begun to dabble in VBA..and to be fair i'm quite amazed at how useful it is. I need your help today with a code i'm writing that would allow me to copy the last visible cell from a given column (B) onto a new sheet, here is my code so far but...

Hi everyone, I'm new to VBA so I apologise if the terms I'm using are incorrect. I'm trying to filter an OLAP PivotField based on the ranges created in second worksheet. The number of filters to perform depend on the number of columns in that worksheet, and only the items in that column are...

Hi I am trying to create a form where there is a drop down boxes for selection of 4 options (cell G12). This is what I would like the programming to do: Cell G12 – there are 4 selections now If blank Rows 36:66 hidden True Rows 80:88 hidden True If DVA Initial Rows 36:50 visible True...

Hi, I have the code ActiveSheet.Range("A10").Offset(1, 0).Select But this does not work for me as my data is filtered. I do not want to unfiltered the data. But how can I use offset on functioning with on the cells that are visible ?

Dears, I would like to kindly ask you for your help with vba code for copying first visible cells after filtering. I have vba which copy / paste everytime value from one fixed cell (A9)....now as need to update file and more variables appearing, I need to copy first visible cell under header...

I found the following thread: https://www.mrexcel.com/forum/excel-questions/995780-sumif-visible-cells-only.html which is great and I love it, but I need to basically do a SUMIFS on visible cells. so How would I put that together? Thanks,

Hi all, Have a sheet I'm filtering and copying the visible cells in this Macro, but in some rare circumstances, once the filter is applied, there are no visible cells. On Error GoTo SkipTourCopyRng.SpecialCells(xlCellTypeVisible).Copy temp.Range("A12")...

Hello everyone, I have a workbook with around 50 sheets or so. I have code written to hide/unhide sheets based on userform inputs. I am stuck trying to write the code for excel to number the visible pages 1, 2, 3...etc. in cells A9 in each sheet. The visible sheets change and are different for...

I need to get the VBA code where it looks in column P, starting at Row 4 and down... AND only looks at only the visible rows in order to get a count for each string that it is looking for Column P contains these 'codes' that represent a checkbox on a userform that was previously checked and if...

never mind... I got it! apologies for the 'false alarm' ;) how do I find the last visible row when starting from the first visible row, but BELOW a certain starting point? So in the example below, the code would need to locate the first visible row that is below row 3, and down to the last...

PURPOSE: If a specfic checkbox on a userform is checked, then it needs to look in a specific cell for a specific string on a worksheet and if found, then that row is to remain visible, and if not then then that row is to be hidden. MY PROBLEM: The range that it is to be searching in has already...

Hi The following code works to make visible all sheets following different views, and i have been trying every syntax for a 1 line solution For Each ws In Sheets ws.Visible = xlSheetVisible Next ws Is there a command like...Application.Sheets.Visible =...

I have sheet tabs name by the year. Only 1 sheet tab will be visible. All other tabs will be hidden. The code below will populate the userform with years (i.e. 2019, 2018, 2017, etc). My current sheet tab (2018) is visible. I would like the combo box to not display the year in the combo box...

I have a sheet with formulas in it and I need to remove them which isn't a problem except one of the cells is creating a problem. I cannot adjust the source data or I would fix it there first. Each cell in the first 3 columns is in a formula format similar to ="xxxx-xx-xxxx" and the formulas are...

Hello, I have a userform where someone can enter a multiplying factor (exchange rate). I want to use this number to multiply the contents of a range of cells (A1:A100) across all visible sheets. Can you help please! Thanks, Nick