#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default Send Keys

And another method.

For Each rngF In rngFilter
If rngF.EntireRow.Hidden = False Then
'' Do your thing.
End If
Next rngF

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Thereafter I want to automatically run down this column
and do specific actions for each value in this column. I
am able to do everything I want EXCEPT run down this
column.


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
Send keys with user input sunspot27 Excel Worksheet Functions 1 August 9th 09 10:20 PM
Send keys from command button sunspot27 Excel Worksheet Functions 0 July 28th 09 12:10 PM
Bypass: A program is trying to send mail using Item.Send prompt Vick Excel Discussion (Misc queries) 1 June 25th 09 03:31 AM
My send to in excel/word does not offer send as attachment Mstink Excel Discussion (Misc queries) 11 March 16th 06 02:49 PM
Send Keys pancho[_14_] Excel Programming 1 August 21st 03 07:54 PM


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