after filtering, change every cell in column J

Posted to microsoft.public.excel.programming

John Keith John Keith is offline

external usenet poster

Posts: 172

after filtering, change every cell in column J

After autofiltering a range of data I next want to change the value of
column J of every row found to "1". What is the mechanism for
specifying the sorted range and changing the value?

John Keith

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
can you change the colour of the arrow from blue when filtering?	clarasmummy	Excel Discussion (Misc queries)	1	May 10th 10 04:06 PM
Keep boarder on merged cell while filtering data in another column	ckc95	Setting up and Configuration of Excel	0	February 2nd 10 09:50 PM
rename column header after filtering column results in the MS SQL	Neall	Excel Programming	1	December 3rd 07 09:05 PM
VBA to address first visible cell in Column "D" after filtering	EagleOne	Excel Discussion (Misc queries)	2	December 11th 06 05:22 PM
trouble filtering a list. Why isn't column filtering?	Pat	Excel Worksheet Functions	1	July 18th 05 03:30 PM

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

Menu

About Us