LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Macro to hide the row if both columns E & F are blank in that row.

Hi,

I am searching for a Macro or Formula that will hide both columns E&F if
they are blank in that row. Example below:

A B C D
E F
Name Exp Rpts Account Name Account # Debit Credit
__________________________________________________ __________
Nov T & L 0400011111 0.00 768.11
AAAA M & E 0400011111 78.81
Leased Auto 0400011111

Any Ideas?

Thanks!

Pcakes


 
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
Need a macro to hide certain columns Dallman Ross Excel Discussion (Misc queries) 12 October 19th 06 05:58 PM
Macro to Split Window in Same Place Even If Columns Added or Hidde PBJ Excel Discussion (Misc queries) 0 September 28th 06 03:06 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
macro to hide columns Shooter Excel Worksheet Functions 2 September 27th 05 09:04 PM
how can hide and show columns using macro? Hoshyar Excel Worksheet Functions 4 September 2nd 05 03:45 PM


All times are GMT +1. The time now is 10:36 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"