visible

  1. J

    Concatenate Visible

    Hi, I am looking to write a formula that will include into one cell all the values that are visible in column A after filtering. Looking online I have only been able to find the below; Public Function ConcatenateVisible(rng As Variant, seperator As String, Optional IGNORE_EMPTY As Boolean =...
  2. willow1985

    VBA Copy visible cells as a picture

    Hello, I have a macro that filters column Q removing blank cells. Once it is filtered to show only the cells with data I am looking for a code that will copy all visible cells from Q2 down and copy them as a picture. Any idea what code I could use? Thank you for all your help! Carla
  3. B

    Referencing information on a hidden sheet?

    I have a number of functions that reference sheets which are only used for lookup, a typical example of this code is; Public Function HaeLaitteet(BoxAr, prdFam) Application.ScreenUpdating = False On Error Resume Next srcSheet = ActiveSheet.Name 'Sheets("My_Sheet_Name").Select For j = 2 To...
  4. T

    VBA: Is there any way to "make all items visible" in a PivotTable Field?

    I recorded a macro by going to a PivotTable, and in the dropdown for the field i was interested in, i checked "Select all)" and then pressed OK. What VBA recorded was this: With ActiveSheet.PivotTables("PivotTable3").PivotFields("Vaca") .PivotItems("excl").Visible = True...
  5. H

    Countif with Criteria only visible cells

    Hello Friends, I am using this formula to count cells if they contain the word DELAY in Cell A1 =COUNTIF(A2:A10,"*"&"Delay"&"*") Here is a sample list From A2 to A10 Delay 25 Days On Time Delay 52 Days Early 12 Days On Time Delay 52 Days Early 12 Days On Time Delay 52 Days I want the...
  6. J

    macro to delete all visible rows in an autofilter

    Hi, I have an autofilter on row 13 and then trying to delete all the visible rows I found somewhere that the below code should work, but it doesn't. Anyone who could help me crack the code? Thanks, Jos Rows("13:13").AutoFilter Field:=5, Criteria1:="22 - Rabobank 370113144" .Offset(1...
  7. C

    Count Unique Visible Values with Criteria

    Hello: Is there a formula that can count only the visible and unique values in a column, based on criteria from another column? This array formula I have counts the unique values with criteria, but it ignores filters and counts non-visible cells...
  8. A

    loop to check if visible

    I have a userform that has multiple labels. 10 labels are named with the leading text lblM_ (see below). I want to check if any of these labels are visible. I kindly ask for assistance with a vba code to check if any of these labels are visible lblM_tbxSch800 lblM_tbxSch900 lblM_tbxSch1000...
  9. S

    Sumif between visible cells only

    Hi I am struggling to find examples on how to sumif between visible cells. Here is the formula I am trying to adapt to visible cells only: If it matters Q4 and R4 are cells with TIME values. =SUMIFS(C:C,G:G,">="&Q4,G:G,"<"&R4) Thanks for any help or direction! SD
  10. D

    Code to make header visible

    I have a spreadsheet that makes a hidden worksheet visible upon clicking a button. How do I make the position of the page be scrolled all the way to the top so you can see the header using vba?
  11. D

    I want my spreadsheet looking good

    Is it possible to centre a worksheet on the page and have only that page visible? I tried to hide the pages but greyed out pages are still visible. I want nothing to be visible, except the active page and I would like it centred on the page. Can someone help me please? Is there a way to publish...
  12. M

    simple code to show a number of rows

    Rows 11-30 and rows 41-60 both are 20 rows (obviously) I need a bit of code that when a user enters a number in cell A1, for example 5, the first 5 rows of each of the above 2 sections is visible, the last 15 rows are hidden Any help would be great :-) TIA
  13. S

    Search for column name in table, replace visible values only in the column

    Hi This is what I am trying to achieve: 1. Enter the column name to find into cell B2 2. Enter the value to populate into this column into cell B3, however the table will be filtered so only visible cells are to be updated. Column_Name 1 will always have a value present in each row so this...
  14. A

    Loop Through Visible Columns within Range

    Hi I’ve managed to use VBA to hide columns in a worksheet that aren’t equal to a cell value, leaving a number of columns visible within the larger range. LastColumn = 300 'Last Column For i = 5 To LastColumn 'Looping through each Column, from column E(5) 'Hide all the columns with the...
  15. K

    Excel VBA Count Number Of Lines From A Merge Cells Range And Wrap Text

    Hi, I have very unique problem here and from past 2 days I searched the answer in google or asked with some other VAB expert but I could not get a answer, please kindly help me to resolve this problem. Problem:- I have multiple footnotes (footnote cells C21, C44, C120, C178 etc.,) in a excel...
  16. U

    Visible cell count CHALLENGE.. wait for it, BETWEEN VALUES!!

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

    Check if all legend items are displayed

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

    Print Visible Cells after Filtering

    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" &...
  19. U

    Count visible cells filtered data

    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)
  20. T

    Personal.xlsb visible but not opening.

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top