Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bill
 
Posts: n/a
Default Macro for Show/Hide Range

I need a Macro to Show / Hide a range called HIDEQUOTE.

The reason why I want to limit a Hide to a RANGE is if a column in the
middle were to be deleted, messing up any hope for Show/Hide column static
reference.

Thanks
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
AFAIK you can only hide rows and/or columns but not a rectangular range

--
Regards
Frank Kabel
Frankfurt, Germany

"Bill" schrieb im Newsbeitrag
...
I need a Macro to Show / Hide a range called HIDEQUOTE.

The reason why I want to limit a Hide to a RANGE is if a column in

the
middle were to be deleted, messing up any hope for Show/Hide column

static
reference.

Thanks


  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

You can only hide whole columns/rows. try to record a macro
while you hide the columns/rows that contain your range

Regards,

Peo Sjoblom

"Bill" wrote:

I need a Macro to Show / Hide a range called HIDEQUOTE.

The reason why I want to limit a Hide to a RANGE is if a column in the
middle were to be deleted, messing up any hope for Show/Hide column static
reference.

Thanks

  #4   Report Post  
Bill
 
Posts: n/a
Default

Thanks to both Frank and Peo for the answer.

In the old Lotus 1-2-3 you were able to hide a range "containing" columns by
using a macro such as
/ w c h r rangename~
which stood for worksheet-column-hide-range-" "

Oh well, you see what I'm saying anyway. Guess there has to be a law in the
office not to delete columns after I've programmed macros :)

"Peo Sjoblom" wrote:

You can only hide whole columns/rows. try to record a macro
while you hide the columns/rows that contain your range

Regards,

Peo Sjoblom

"Bill" wrote:

I need a Macro to Show / Hide a range called HIDEQUOTE.

The reason why I want to limit a Hide to a RANGE is if a column in the
middle were to be deleted, messing up any hope for Show/Hide column static
reference.

Thanks

Reply
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
Setting source data range with Charts D Charts and Charting in Excel 2 January 1st 06 03:51 AM
select worksheet to run macro Hidaya Excel Discussion (Misc queries) 5 December 2nd 04 12:54 AM
Macro help Jeff Garrett Excel Discussion (Misc queries) 11 December 1st 04 09:47 PM
macro interruption: help!!! mario milani Excel Discussion (Misc queries) 1 November 30th 04 07:02 PM
Range in VBA Jeff Excel Discussion (Misc queries) 1 November 26th 04 04:54 PM


All times are GMT +1. The time now is 01:04 AM.

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

About Us

"It's about Microsoft Excel"