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: 1
Default Excel Programming

I work with reports which look like charts with a first row that contains names of the columns and following rows contain either number or word.
So I need to find cells with wrong values.
For example, a cell has to contain a number, but it might be either not filled or have a wrong value (too big or too small).
and I need VBA to help me find those kinds of celss and give me the report ID number which is the 1st column.
and color those cells.
Can anyone help!? REALLY IMPORTANT!


Submitted via EggHeadCafe - Software Developer Portal of Choice
Bamboo Prevalence Redux: BAMBlog Blogger App
http://www.eggheadcafe.com/tutorials...nce-redux.aspx
 
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
New to Excel Programming Azhar Excel Programming 3 January 20th 09 05:46 PM
excel programming Wendy Elizabeth Charts and Charting in Excel 2 June 19th 07 04:21 AM
programming in excel smm Excel Programming 2 March 9th 07 07:00 AM
New to programming VB in Excel Rick Excel Programming 5 May 6th 05 05:44 AM
Excel Programming help Geoff D'Arcy Excel Worksheet Functions 2 November 1st 04 06:31 PM


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