visible

  1. P

    Hiding worksheets when opening excel using VBA code

    Hi I have built a workbook with VBA code that when you open it, it only shows the first worksheet (there are 4 worksheets in total in the workbook). The remaining 3 worksheets are not visible until you click a command button. When you click the command button on the first worksheet, the...
  2. S

    Finding Total Number of ColumnLevels and Entire Rows of Visible Cells - which may have some columns that are not visible.

    I am trying to remove entire rows that filter on certain criteria. I'm doing it by writing: Range(Cells(3, 1), Cells(LastRow, LastColumn)).SpecialCells(xlCellTypeVisible).EntireRow.Delete But I have grouped columns in my data so I get errors. My work around is to write...
  3. S

    Change to 'copy visible'?

    Hello! I am a brand new member, long time Excel user. Yesterday, thought I had lost it; Here; https://support.office.com/en-us/article/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e It says this; And that has always been true in my experience. I remember finding Alt+...
  4. H

    excel vba : how to make hidden members visible

    Hi, I tried to copy a set of data from sheet "RawData" which was filtered and paste it at sheet c but there is something wrong in the code line "ActiveSheet.Paste", it says "cannot jump to active sheet as it is hidden". When I click excel help, it says "You specified a name that is in the type...
  5. P

    Please Help: Userform acting like I'm double clicking

    I have a userform with a listbox. When a selection is made from this listbox, controls become visible depending on the selection made, and this listbox becomes invisible. When I make 1 certain selection the alignment of another listbox that becomes visible is right where the original listbox is...
  6. V

    All the data labels on Scatter graphs are not visible

    Guys- i have created a scatter graph and for someof the data labels arent visible? could see the image attached for further details. thanks
  7. K

    VBA code for an 'IF' statement that checks for a value within a range of visible columns... (ignoring hidden columns/cells)

    Here is a picture of my spreadsheet and what I am trying to figure out how to get it to do what I need it to do: The selected row (row 5) shows some cells that contain either a value of either "R" or "E". I need a If statement that checks a range of: Range(Cells(5, 6), Cells(5, lCol)), but...
  8. K

    VBA error when trying to delete visible rows

    Greetings all, I am trying to run a script which is supposed to delete the visible rows from a table I've filtered. However, when the script is ran it comes up with error msg: :warning: "Runtime error '1004': Delete method of range class failed. :eeek: I have tried it two different ways...
  9. N

    Count Visible Negative Cells, but not duplicates???

    Hi All, Really struggling with this one. I've got a formula that counts only the visible filtered negative numbers, however, it gets more complex as I don't want it to count it if it's a duplicate in relation to a despatch number. Please see example table below. My current formula counts the...
  10. B

    function that returns first visible cell test

    Hi, I'm trying to get a function that returns first visible cell text (not number). Cell range is B7:B8000 but after filtering, the range can come down to 50-60ish cells, but i only need the first cell out of the filtered range. Thanks Bizzbuzz05
  11. C

    Counting only visible entries in a filtered table

    Hello, I have a formula that calculates Deals 'Won'' as a % of Total Deals ('Won'+'Lost'). <tbody> =IFERROR((COUNTIF(Tbl_Deals_1[Status],"WON")/SUM(COUNTIF(Tbl_Deals_1[Status],"WON"),COUNTIF(Tbl_Deals_1[Status],"LOST"))),"") </tbody> It works fine, but I want it to only calculate for...
  12. N

    Offset referencing only working for formulas, not copying? [VBA]

    I have two 'with' statements that select first visible cell and it's not selecting visible cells in column in order to copy+pastevalue. I just want it to: select first visible cell in column AR=>select down to last visible cell in AR=>copy=>pastevalues I used this exact structure for RC[-1]...
  13. N

    vba code to return range values (text) to message box after autofilter

    Hallo. After using the autofilter, the visible cells text values should be returned on message box. My initial code is below. The problem is that it returns only 1st visible cell's value. Sub Wood()Dim rngVisible As Range Dim xStr As String Set rngVisible = Range("A2:A" & Cells(Rows.Count...
  14. L

    VBA Code to Disable or make Not Visible Excel Menus

    Been trying to figure this out for a couple of days now - Just need to either disable or make not visible most of the Standard Excel Menus (Insert,Draw,Page Layout, Formulas, Data, Review,View, Developer) when the Workbook becomes Active and then put them back on close or deactive Thanks in...
  15. F

    counting non hidden rows in VBA

    After filtering a worksheet I would like to sequentially number each row for the non hidden rows row status 1 visible 1 2 hidden 3 hidden 4 visible 2 5 visible 3 Thanks
  16. D

    Copy filtered range and paste to filtered range

    I have 2 sheets, both have auto filters applied. I need to copy the visible cells from sheet1 and paste them to only the visible cells in sheet2. Nothing I have found online allows me to do this. This is the closest I've seen to working...
  17. S

    how to fix the Grid lines missing in Excel

    The Grid lines just not visible on a PC. following things I have tried. 1. The Gridlines are check-marked 2. I selected the whole sheet and gave "No fill" to Fill colour. 3. I went to Excel option, went into Advanced section, in Display section, the Gridline colour is black. After all these...
  18. P

    Filter and delete visible rows

    Hi All, Could anyone provide me with a simple way to do the following Sheet1 (my main worksheet) Cell A2 is my Filter Title Cell A3:CH3 downwards contains the information I wish to filter I want to filter column A (Data From A3 to Axxx) to select the word DELETE (I have a routine to mark...
  19. hicksi

    Obtaining Windows credentials from VBA

    Suppose I have, on my single visible sheet, a button. When the user clicks the button, it prompts for a username/password (default username is currently-logged-in) Is it possible to use Windows authentication to verify that the entered username/password are correct WITHOUT STORING ANYTHING? If...
  20. J

    VBA .SpecialCells(xlCellTypeVisible).Copy Function

    My code below keeps error and there isn't any visible mistake, please help.. Thanks wb2.Sheets(1).Range(Trim(Arr2(0)) & FoundCell3 & ":" & Trim(Arr2(UBound(Arr2))) & FoundCell4).SpecialCells(xlCellTypeVisible).Copy

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top