View Single Post
 
Old 05-10-2023, 04:28 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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.
Reply With Quote