visible sheets

I have worksheet A, B, C, D, E, & a I have data in cells G5:G15 of sheets B, C, D, & E I want to count the total cells in each sheet with values "xx" that are visible except in sheets A and a.

I have a Excel 2013 workbook that I have created. I have a number of worksheets which I want to hide so that when a user opens the Workbook only the "Table of Content" shows. On this worksheet I have a set of buttons that should take the user to the right worksheet. If I do not hide the...

I have a folder named Import containing numerous excel files (all starting with OBR) and within those files I only want to import the visible tabs not any hidden tabs into an excel file called 'Ops Board Report'. The Import folder where all the files I want to import into the Board Report are...

Hi everyone, I'm new to this so please excuse me for anything I have missed out. Basically, I have a pivot table in worksheet "Summary" that I want to copy and then depending on which is easier: • preferably, paste special into all visible worksheets at Cell (A1), • or paste special into all...

Hello there! I've been using VBA for a few months and so far it's been a very fulfilling experience. Just this one time i've bumped into a weird problem and were not able to find a solution. It goes like this. I am designing a "Settings" tab on a fairly large report. It has data sheets...

I am attempting to move all of my visible sheets to a new word document. I have set up the portion of the macro that makes the appropriate sheets visible using IF statements. That works fine. Below is a code which moves all of the sheets (including hidden sheets) into a new word document. I am...

Hi I'm trying to retrieve the worksheet names to a specif cell and populate from that point only with the names of the visible sheets, but It keeps returning only the last visible sheet name and not the sheets that are visible. Could someone plase point me to where the code is failling - I'm...