Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and SQL dump changing the cell types in other worksheets
I have written a piece of code which runs a SQL script and then outputs this
to Sheet 2 of my workbook. The code contains no cell formatting as this has all been previously applied to the columns manually. However when i run the code using a button on Sheet 1, the types which have been applied to the colmuns in sheet 2 are also applied to the same columns in sheet 1. No matter how many times i re-format the cells, each time i run the code it does the exact same thing. Any help for this would be great as it is the last problem I have to get around and it is driving me nuts. Cheers, -- Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I hide unused file types from file types list in save dial | Excel Discussion (Misc queries) | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
Changing footers on all worksheets without changing print set up | Excel Discussion (Misc queries) | |||
Changing chart types with series | Charts and Charting in Excel | |||
Changing data types on Line/bar with two axes | Charts and Charting in Excel |