visible

Ive got a vba script i am writing that I need help with. So I am the stage where after auto filtering the dataset in Excel, I need to copy values down a column from a particular position. So what I have done is to identify the column header I need to copy values from, offset down two cells and...

Hi all, I'm trying to work a formula that always subtracts the 3rd visible row and cell data from the 2nd visible row and cell data to return the result from a filtered list. Every time i filter it returns 3 rows of data (a header, and 2018 data and 2017 data). But when you filter different...

Hi, I've been looking for a solution to my problem for a few weeks now. I've allready posted my question on Ozgrid, but I'm still stuck. Hopefully there's someone here to help me out... So here's my problem: I have a workbook containing two worksheets that should be allways visible. So a...

Was designing a Form and everything working fine when all of a sudden everything you click on "dings" at you. I have to Control-Beak and the code is hung on the Line MyForm.Show. Pressing F8 re-runs the same subroutine and/or (at times) has brought up Run-time error '400': Form already...

hello, So far I have this code. but not working for visible cells. Any idea, please! For Each j In Range("A2:FL" & lastRow).SpecialCells(xlCellTypeVisible) ii = j.Row If Rows(ii).EntireRow.Visible = True Then If Range("V") <> "" Or Range("V") <> vbNullString Then _...

Hello all: I am creating a VBA workbook with UserForm to allow users to input data. I do not want the workbook to be visible to the user and have used "application visible=false" code. Everything appears to be working just as I want, however, I do not want to add a button/code the userform to...

I have a master price list for ordering stock and the following code works as long as I'm always ordering from all suppliers. I filter out the all items which are being ordered when quantity required column is greater than zero (field 11 > 0) Then I filter by supplier column (field 2) and copy...

Hello, Below a part of a code. I wan't to change a part of this. Sheets X was always vidible, but it may only be visible if the valeu on 'Sheet11 cell A1 = > 5' I have test it whit the IIf function, but i make some little mistake... Sub Generate () t = Sheets("Sheet 1").Cells(3, 1).Value...

Hi Experts I have a table where I have rows grouped above and below and only few rows remain visible. (I'm attaching table picture for reference) Now I need a vba where I could select all visible rows - Leaving one from above and one from below. As in this Picture - Rows 1169 to 1181 are...

Hi I'm developing a game in Excel. I have two hidden buttons for "yes" or "no" answers which become visible when a shape is clicked. However, when they do become .visible=msotrue they don't work. Yet if I click another command button that has always been visible, they both become active...

Hello, I am trying to count unique cells in a filtered list. The macro I have to count total unique cells seems to work perfectly. but i'm trying to change it in two ways.. First is to have it count the unique cells that are not filtered/visible (visibility is set my filters, not group &...

[Excel 2007] CS Analysis.xlsm is a macro hidden workbook with all the buttons to run macros in the Add-Ins tab. The workbook does contain a few worksheets with info that I use for the macros. In the last few days, whenever I open it the window appears as a small frame, even though in the View...

I have 100 sheets in a workbook that have dynamic names. The sheet numbers are static and start in G14 and continue to G113 in column H starting at H14:H113 is a "NO" "YES" designator to say if the sheet should be visible or not. I would like the sheets to hide or unhide on the selection of...

I wrote a spreadsheet for a chum some 3 years ago. Now it seems there is an anomaly (!) and I need to 'have a look' The workbook has 3 sheets one of which is hidden. I need help to make this sheet visible All sheets are unprotected The workbook is unprotected I have tried Right Click on a...

Hi I got error message running the second sub. I thought x would be visible to consequence subs but I guess that is not the case. How can I make x visible to all other subs? Thank you. Sub workbooksoepn() Dim x As Workbook Set x = Workbooks.Open("C:\Users\userme\Desktop\abc.xlsx") End Sub...

Hi Everyone, I'm a newbie to the forum & only a beginner in VBA trying to self teach myself as I did with MS Excel, so would be grateful for your assistance & advice. So here's my problem... I've got a large data set table of information with various row records identified by a unique...

Hi there, Im fairly new to Power BI s leasebear with me. I have a typical ln chart that has 20+ lines and when I interrogate a couple of lines, obviosuly those lines not selected fade to the background, however, they are still too visible and make analysis of the selected data distracting. Is...

When I was using Excel 2010 I had no problems opening a UserForm in one Workbook, then selecting another Workbook and the UserForm would stay visible. That doesn't happen in Windows 10 + Excel 2016... If I open the UserForm it will hide when I change to another Workbook, and I'm loading the form...

Hello all you Gurus out there. I need a little help. So in "ThisWorkbook" I have these lines of code sht.EnbleOutlining = true sht.protect Allowfiltering:=True What code can I put in here that I am able to "Select Visible Cells Only"? I need this to be able to paste in data to only those...

I have a userform and a combox in the userform. the combox ragne is autofilled from sheet 1 range c3 till the last record. I am not sure, If the user selects any record from me.combox then the code should do autofilter from c3:aa500, (c3 to aa3 are header) and then should stop at the visible...