|
|
#2
05-10-2023, 04:28 AM
|
||||
|
||||
It worked here, but note that:
1. I had to use: fs.Visible=True so that I could see the workbook 2. strTargetSheet contained an empty string, so I had to add a line like: strTargetSheet="MyNewName" After which the column was correctly formatted. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed | daviddyer2902 | Excel | 1 | 03-06-2023 02:24 AM |
| Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date | trevorc | Excel Programming | 1 | 03-04-2021 02:39 PM |
| "Uppercase" in Master Layout doesn't work in actual slides | BDesign | PowerPoint | 2 | 07-03-2019 07:06 AM |
 Formula to format "I" column based on if "F" column row is not blank
|
ravl13 | Excel | 3 | 08-22-2017 12:26 PM |
|
Why the "table of contents" doesn't take the same format of the "headings"?
|
Jamal NUMAN | Word | 5 | 06-15-2011 10:14 AM |
Windows 10 
Office 2019
Threaded Mode