visible

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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