Dear Guys and Guls, I am new to VBA although I have used Excel extensively. Have looked for solutions to this without any luck. Would appreciate your feedback. In between a long VBA macro, I need to copy the result of autofiltering i.e. The visible cells / rows only, to paste on an other sheet. If I do this manualy it works but if I record this on a macro, it records the absolute cells range I pick, when in fact the result of the filtering is different every time. Download chrom driver for mac. Is there a way arownd this with VBA or am I asking too much?

Hello - I am using Excel 2007. In prior versions of excel, when copying data, if I wanted to copy visible cells only, I would select 'Go To, Special, Visible Cells Only' and then copy a range a cells. The default was always set to copy everything (including hidden cells), unless I specifically selected copy visible cells only. In 2007, the default is somehow set to always copy only visible cells. Sometimes, I want to be able to copy all cells including those hidden but cannot seem to figure out how to swith this default option. I looked under Excel Options and did not see an option there.

I don't want to have to unhide and rehide everything each time i copy. I know i could do the hiding and unhiding via VBA but would prefer not to have to. Thanks for your suggestions. I have set up a workbook that is sent out to lots of different users. They each keep and use their own copy. I have set it up so that everything looks OK and is visible on MY screen, but I'm conscious that some users may have different screen sizes, different toolbars set up, and so on, which might make some parts not immediately visible to them. I have set up an auto-execute macro which automatically sets the zoom factor to best fit, for several of the worksheets, and this works fine.

Sat nav technology has migrated to your pocket and your dashboard. We round up the best GPS map and navigation apps for iPhone and iPad, many of which also work offline, so you can navigate. Best Sat Nav. If you are looking for the best sat nav, then you have come to the right place. Gone are the days when you needed to spend thousands of pounds on a sat nav, but these days the technology has become extremely simplified and available. Not all sat navs come from a box, so unless your car is a model which comes with its own built in sat nav, the best sat nav can come in two ways – a standalone device that fits snugly onto the windshield or on the dashboard, or an app downloaded onto your phone. Maps cost money. Best sat nav for mac download. I can confirm that tomtom are mac compatible. The best way to check is go onto the companies website and see if there is a mac version of the software available, if there is, then you know that you not only have mac compatibility, but some support as well.

Here's the code that does it. Code: Sheets('WELCOME').Select Range('A1:N18').Select ActiveWindow.Zoom = True By repeating this code for each worksheet, I can make each one be zoomed just right. However, the file contains 8 sheets that are all identically laid out, except the number of rows is different.

What I want to do is go to the worksheet that has the largest number of rows (it's always the same worksheet, so I know which one it is), set the zoom factor for THAT worksheet (which I can do, and it always has the same number of rows), and then take THAT zoom factor, whatever it is - and it will vary depending on the user - and apply that to the other worksheets that have a similar layout. I could just go through each worksheet and zoom it automatically, but that would mean that some of the sheets looked very large, others very small, and I'd like them to have a consistent appearance. I could also specify a range on each worksheet that was similar to the appropriate range on the longest worksheet, and zoom that automatically, but that's not ideal either, because some of the row heights vary from sheet to sheet, and again I'll end up with different font sizes.