LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 93
Default hiding columns; dynamic

This won't work... functions cannot "access" anything outside of its
own cell? So, I need a sheet event to run this.

After a cell value changes anywhere on the sheet, or something, I want
to recognize 'calculations complete' and then run a column hiding sub
(). Or, I think that's what I want. I need to hide columns based on
data and it appears a user function won't do it. Suggestions? Thank
you in advance.


NO GO below (doesn't hide itself) (maybe a bug?)

Function columnVisibility(hide_if_lt_zero As Long)

Dim myRng As Range
Set myRng = Application.ThisCell

If hide_if_lt_zero < 0 Then
myRng.EntireColumn.Hidden = True
Else
myRng.EntireColumn.Hidden = False
End If

columnVisibility = 0#

End Function
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding Columns SnareHiHat Excel Discussion (Misc queries) 2 October 16th 09 02:10 PM
Hiding zeros in dynamic charts Carla Charts and Charting in Excel 3 April 22nd 08 08:46 PM
hiding columns JT Excel Programming 0 September 6th 07 08:22 PM
Help with hiding columns ExcelDave Excel Programming 3 May 27th 06 12:46 AM
Hiding Columns Ruan[_3_] Excel Programming 0 November 13th 03 11:42 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"