visible cells only

  1. B

    Returning only visible data for RANDARRAY

    Hi. I am creating a question bank for a module that is made up of multiple class studies. I have created the full question bank and I am using RANDARRAY function to return a random test paper. Initially I just wanted to create an end of module test but now I've been asked if I can use the bank...
  2. J

    How to modify this UDF for visible cells only?

    Hey everyone, I’ve got this user-defined function that I use to calculate a statistical measure for a range of cells. I’d like to modify it so that it only evaluates the visible cells within the range, but I’m not sure exactly how… Here’s the current code: Function COD(r As Range) As Double...
  3. V

    Write to First Visible Cell after autoFilter in VBA

    Hello Have a great day, I am very new to Macros and want to create a dynamic macro and automate my day to day task . I wrote code to copy data from other workbooks and append it on other workbook(testmac) I applied a filter and select the All amount which are greater than Zero in Column K Now...
  4. S

    Autofilter Multiple Criteria, Copy and Paste Visible cells only excluding header

    Requesting help with setting up a macro to autofilter multiple criteria, copying visible data only, and selecting and pasting sections of the data at a time into another worksheet in the file. Here is a previous post that works for single criteria...
  5. H

    Match all values within a filtered range based on multiple criteria

    Hello All, I've started playing with VBA some days ago, thus I'm new with Excel coding. Below is a simplified version of the sheet I want to extrapolate the data from (sheet name "Data"): <tbody> Customer Platform Program Motor Type A 1 pr1 aa A 1 pr2 aa A 1 pr3 aa A 1 pr4 cc A 1...
  6. H

    Copy Visible Cells after filter if no data don't copy

    Hi Team, I know this is something can get it online but I could not get it and leads to lots of confusion. I need help in copying visible cells. For Example I have columns from A to AE and want to filter something on column AE and code should select only visible cells post filtered and copy...
  7. H

    Top 10 Visible cells copy and paste Vba

    Hi Team, Could you please help me with code for exact requirement ..I have data from column B to P and need to filter on column P say "One" and need to copy only data from column B to Column D -top 10 visible cells (excluding header which is there at row 5) and need to paste it in different...
  8. 3

    Selecting and Copying Cells in Range if not blank AND are not hidden

    Hey Folks! I'm trying to select and then copy cells within a range if a there is data in a specific column. If there is, I need it to copy all those cells in that row range even if it has some blanks in other cells in that range. I was trying this: Sub CopyPt6() If ActiveCell = ""...
  9. M

    Help with VBA dropdownlist print macro & visible cells range

    Hello everyone Hope someone can help. In a bit of a head banger & up against a deadline. I have a print macro which prints out all of the items selected in a list box loaded into a user form. Works perfectly. Now I need it to only print out the visible range based on filter results. Tried &...
  10. G

    CommaDelimit by Join(Application.Transpose visible range

    I currently comma delimit using this and put it to the clipboard using MSForms.DataObject Dim ConvertComma ConvertComma = Join(Application.Transpose(Selection.Value), ", ") Dim clipboard As MSForms.DataObject Set clipboard = New MSForms.DataObject clipboard.SetText...
  11. O

    SumProduct of Only Visible Rows

    Hi All i have a Sheet in which Rows 1 to 3004 having Diffrent values in Column I total on rows 5 to 3004 in row no 3006 as sum product of Every 3rd Row as =SUMPRODUCT(I$5:I$3004*(MOD(ROW(I$5:I$3004),3)=0)) with this formula i got sum value of row no. 6,9,12,15.......3000 and 3003 but i want...
  12. A

    Copy visible autofiltered data -- VBA

    Hey guys so I'm pretty beginner at VBA and have been working on making a macro with VBA to extract some data from a different workbook than the current one that starts the macro. So right now this is the code that I have: Sub Macro8() Dim fd As FileDialog Dim OpenOrder As String Dim...
  13. D

    VBA to save only Visible cells in PDF

    Hi guys, I have the following code (below) which saves my active worksheet as a PDF. It works fine, however, my sheet has approximately 8000 rows, with an autofilter and the information i see on the screen is not reflected on the PDF (i.e: the info I have is 300 rows, but my PDF shows the full...
  14. O

    Using VBA to find filtered Pivot Table column data returns all data in that column

    Hi, I am trying to iterate over all cells of a specific column in a pivot table, to fetch values of filtered data only. However, it returns all cells in the pivot table column, including the ones that are filtered out. The Pivot Table sits in another sheet than the one I am working with, hence...
  15. D

    Select cells with visible data only

    I am hoping this is a simple question. I have a list of 3,000 rows 6 columns doing vlookups and other formulas. I would like to know how to select cells with only visible data. I want to subtotal the data before printing but I get 200 pages because the grand total is 3000 lines down. I...
  16. L

    Copy and Paste visible cells only

    Hi All, I'm trying to copy and paste visible cells only. for instance; I have columns A to Z but I columns C to H hidden When I use Alt+; or Find & Select>Go To Special>Visible Cells Only it selects only the visible cells. I can see the perforated line separating the columns. However when I...
  17. S

    VBA range to powerpoint - copy visible cells only? Or copy non-contiguous range?

    Hello, First-time poster with a rather time-sensitive question. Some coding familiarity, but not specifically with VBA, so I keep tripping on syntax. Been banging my head against this for hours, so any pointers are greatly appreciated! So I'm trying to export a large table from excel to...
  18. 9tanstaafl9

    Is the VISIBLE cell above activecell bold?

    I need to test to see if the VISIBLE cell that appears to be directly above my ACTIVE cell is bold or not. I tried using activecell.offset(-1,0) but that doesn't work since there is often a hidden row where this may or may not be true. I have no idea what row the next visible row will be...
  19. D

    F2+Ctrl+Shift+Enter for Each Cell in Range

    Hi all, I would like to use a macro to update all visible cells in range O13:BB700. These cells contain custom formulas that require Ctrl+Shift+Enter to update. The hidden cells can be skipped to save time. Any help would be much appreciated. Thanks in advance.
  20. J

    COUNTIFS/ SUMIF only visible cells

    Hi I'm wandering if anyone can help me. Im looking for a formula where I can apply COUNTIFS and SUMIF functions to only visible cells. The SUBTOTAL function will not do in this case. Any help with this issue would be greatly appreciated. Thanks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back