Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Deleting columns if condition is satisfied

Hi,

i need a macro that can delete columns a&b; c&d;.... ; .... if the belonging
cell-value tjeck in a1+b1; ..+.. is equal to zero. This is repeated until
the cell-value tjeck is empty/missing.

Thanks in advance, hope someone can help me

Kent

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 789
Default Deleting columns if condition is satisfied

Hi
no idea what you want to do. Can you give an example?

regards
Paul

kent-dk wrote:
Hi,

i need a macro that can delete columns a&b; c&d;.... ; .... if the belonging
cell-value tjeck in a1+b1; ..+.. is equal to zero. This is repeated until
the cell-value tjeck is empty/missing.

Thanks in advance, hope someone can help me

Kent

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming


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
Formula to get data when condition is satisfied Kashyap Excel Worksheet Functions 1 November 10th 08 01:17 PM
countif and sum if if two condition are satisfied zafar62 Excel Worksheet Functions 3 July 15th 08 06:22 AM
Looping till condition is satisfied? Jo[_2_] Excel Worksheet Functions 3 October 4th 07 09:43 PM
Copy sheets only if condition is satisfied (mat) matthias Excel Programming 7 April 10th 06 06:06 PM
How to change the value of a cell when a condition is satisfied, but not otherwise? benzi_k_ahamed Excel Discussion (Misc queries) 0 January 11th 06 11:31 AM


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

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"