Posted to microsoft.public.excel.programming

Hamster[_2_] Hamster[_2_] is offline

external usenet poster

Posts: 1

Use specialcells to identify specific values

Hi,

there is a list with different values in it. The values are already
selected using a range. How can I mark those values in the range that
are zero?

Example of the code used so far (the variables Start, End, Nulls have
been filled already):

Range(Cells(Start, Nulls), Cells(End, Nulls)).Select
Selection.SpecialCells(????)

Thanks in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Identify last date of a specific month	Papa Jonah	Excel Programming	8	March 4th 10 02:18 AM
Can I use a formula to identify WHICH row contains specific data?	ExcelTrouble	Excel Worksheet Functions	2	October 3rd 08 12:13 AM
Identify the row with specific criteria	Billy L[_2_]	Excel Worksheet Functions	5	January 8th 08 02:06 AM
formula to identify specific cells	dmack	Excel Discussion (Misc queries)	1	June 21st 07 11:28 PM
identify and move specific values	phyrn	Excel Programming	0	September 17th 04 08:53 PM

All times are GMT +1. The time now is 10:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us