visible

Hi All, I have three columns. Column A - ID , Column B - Price and Column C = Variation In Price. I need to first filter column A for one ID, then apply the formula in the second visible cell in Column C not counting the header - =IF(1-(B3/$B$2)=0,"OK",-1*(1-(B3/$B$2))) and drag this formula...

I am wondering if there can be buttons on multiple worksheets to hide or unhide a single worksheet? ThisWorkbook.Worksheets("jun payroll").Visible = xlSheetVisible for example the code above makes jun payroll visible using a button on sheet1, but can sheet2 have the a button to make the same...

I have a UserForm with the first TextBox that if any text is entered then two new textbooks become visible. The problem is that I cannot get the Focus to move to the first of these just visible Textboxes. I have tried many things but unsuccessfully. Any help or ideas would be welcomed. My...

Here's a bit of a puzzler. I built a code to do the following steps: 1. Apply a filter 2. Copy visible cells 3. Paste the visible cells to a new sheet 4. Rename the new sheet 5. Migrate back to the old sheet and delete the visible rows (thus removing them from the unfiltered data) Trouble is...

I have a file of product numbers that contain both letters and numbers. Some of the products have an apostrophe in front of the first digit (Ex: '71245, or 'P1278) that is only visible in the formula bar when you select the cell. The apostrophe is not visible in the cell when unselected. I want...

Hi Guys.... Does anyone know a way to discover which is the rightmost column IN VIEW in a Window showing an Excel Worksheet with column A as its leftmost column? I'm visually impaired, so I use a low resolution, and normally I can see col L with Excel in full screen mode. I'm trying to use...

Hi, We can Show or Hide a comment using the Excel Menu. Suppose I select a range on my Excel sheet. Say, there are 5 comments in that range: 4 of them are visible (Show comments) and 1 is hidden (Hide comments). How can we write a VBA macro that will count the number of visible comments, and...

In excel, you can easily copy a specified amount of columns in between columns. I'd like to be able to have rows of data already filtered based on criteria, and then be able to insert a certain amount of columns in between all the rows that are currently visible is there anyway to do that?

Hi I have run into a roadblock that I just can't figure out, I would really appreciate any help I can get. On sheet 2 in B2 there is a data validation drop down list that has 6 different options. What I need to happen is that on sheets 6, 8, and 9 for an embedded word doc "Object 1" to be...

I would like to have a certain range visible or hidden. Similar to entire columns/rows, but only the range. Let's say B2:F10 Is this possible? Thank you,

I need to count the number of visible cells with data after filtering. Example- Range is: A2-A66, Filter out array of 15 cells. How many cells/rows are left? I tried the "COUNT" formula, but this is not correct.

I have an excel workbook and it regularly errors out on people when 1 of two conditions are not met when a macro is run, so I would like to actually check it as part of the macro rather than getting an excel error. One is if "Sheet 10" is not visible. This usually indicates that there is no...

When I try to save as the Microsoft Excel 2010 worksheet in HTML format, it is not visible in Google Chrome but it is visible in Internet Explorer 11. I looked at the HTML source and it seems it must be visible but perhaps there is some tag which makes it difficult for Google Chrome to display...

Hi all, Excel 2007 I have created a macro to create charts. This macro decide creation of 3D or 2D charts based on parameters selected for X and Y axis. If parameters for both axis are selected is gives 3D chart. If parameter of single axis selected giving 2D charts. Every time it deletes the...

I have a range of data with filters on. I have a macro that applies one of the filters and what I now want to do is just enter a "1" in Column A next to cells that are visible when filtered. I have tried having a variable and adding one to the variable to move to the next cell and also using...

<tbody> A B C D E F 1 DATA 2 Name ReportID Date Conf. # 3 KDWZ A44 1/1/19 =INDEX(Sheet2!C:C,MATCH(B3,Sheet2!B:B) 4 BLSN B62 1/5/19 5 FIVT Z73 4/5/18 </tbody> Hi! Is there a way to insert a formula on he first visible row after headers on a...

Hello Friends, I am using this formula to count unique values in a range =SUM(IF(FREQUENCY(IF(LEN(orders_ref)>0,MATCH(orders_ref,orders_ref,0),""),IF(LEN(orders_ref)>0,MATCH(orders_ref,orders_ref,0),""))>0,1)) I want this formula to count only visible cells.... If anyone can provide a...

While filling out an online form, new hidden fields become visible depending on the options you have previously chosen. My question is: Why do these hidden fields become visible while filling out the form manually (selecting and clicking the mouse in real time) but NOT when filling out...

Hi all I have encountered strange problem with named ranges, some named ranges are visible in navigation, but others are not. All named ranges are scoped to workbook (according name manager). What leads to this? I have excel template with named ranges, to this template executable VB.NET code...

I'm trying to write vba where column O will first filter out #N/A, and copy visible cells only (I have this code below). Next (I can't figure out without error), I want to copy this filtered/visible range from column O to the same visible range in column M. When I manually try: Select Range ->...