ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Not Printing cells (https://www.excelbanter.com/excel-programming/329235-not-printing-cells.html)

tom

Not Printing cells
 
Hello, i am automating with Foxpro. everything is fine with one exception. i
have a formula in column G, i am hiding it from viewing, but it still prints
out and i need it not to. how do i go about this?

thanks in advance.

Tom

Tom Ogilvy

Not Printing cells
 
How are you hiding it from viewing?

--
Regards,
Tom Ogilvy


"Tom" wrote in message
...
Hello, i am automating with Foxpro. everything is fine with one exception.

i
have a formula in column G, i am hiding it from viewing, but it still

prints
out and i need it not to. how do i go about this?

thanks in advance.

Tom




tom

Not Printing cells
 
osheet.Columns("G:G").Hidden = .T.



"Tom Ogilvy" wrote:

How are you hiding it from viewing?

--
Regards,
Tom Ogilvy


"Tom" wrote in message
...
Hello, i am automating with Foxpro. everything is fine with one exception.

i
have a formula in column G, i am hiding it from viewing, but it still

prints
out and i need it not to. how do i go about this?

thanks in advance.

Tom





Tom Ogilvy

Not Printing cells
 
I know .T. is true in foxpro, but it isn't in COM I wouldn't think. Try

oSheet.columns("G:G").Hidden = -1

--
Regards,
Tom Ogilvy

"Tom" wrote in message
...
osheet.Columns("G:G").Hidden = .T.



"Tom Ogilvy" wrote:

How are you hiding it from viewing?

--
Regards,
Tom Ogilvy


"Tom" wrote in message
...
Hello, i am automating with Foxpro. everything is fine with one

exception.
i
have a formula in column G, i am hiding it from viewing, but it still

prints
out and i need it not to. how do i go about this?

thanks in advance.

Tom








All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com