What vba would set the zoom to selected range of a1:c1 on sheet 2 for example when sheet 2 became active
Posts by Dovrox
-
-
Dave - I have a workbook that I have been developing for months and I keep on finding that I get to a stage with this workbook that for me to be able to cut and paste I first have to enter design mode otherwise the functions are not available. There is a lot of vba involved and it may be something dumb like turning off screenupdating and having an error stop the code so screenupdating may just need turning on......
I just thought that before re-inventing the wheel, someone out there may have seen this before.
It would be great to be able to push an application.status button.
-
Many Thanks - If I have seen using CountA that 3 cells have data then I need to be able to select the range A4:A10 that should be empty So that I can check it is empty.
This is to check if data was not correctly filled from the left of the range.
Perhaps a cell was left out.
-
If Range A1:A10 must have data entered in some cells starting from the left, then how in vba could I determine a range variable for all of the blank cells in A1:A10
-
I Have seen sheets with 5 columns and 3 rows but can't work out how this is done. Seems like I am not using correct words to search help.
-
Why will Excel sometimes only allow cut and paste if you first enter design mode.
-
Company has generated thousands of spreadsheets with a bad filing system.
They have copies of copies all over disk.
I have written a sub to test each file for a condition to see what I can bin.
Many thanks for the help.
Cheers from South Africa.... -
Many thanks but am not looking to read a folder - am looking to see every folder on that hard disc and then check each folder for XLS files.
-
What code would allow you to specify a drive letter and it would read the directory structure of that drive into an array so that each folder could be checked for XLS files.
-
What VBA could check to see if a worksheet is currently open or being used by one user on a network?????
-
Trying to look through all workbooks in a directory to check for the existence of a certain worksheet in each of the workbooks.
-
What VBA would I use to read the path and name of every xls file on a drive into an array.
-
What VBA could I use to check all xls files in a folder for the existence of a worksheet named "costing".