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: 6
Default Run a macro only for the selected fields(records)

Hoi,

At this moment I have a macro which run an action for all the records
within the sheet.
The macro looks in column A and if filled in with a value "y" it runs
the action for the first row and when finished it goes to the next
record till the last one in the sheet. For info: This macro copies
date of the activ record to a sheet and then print it out.
I want to change this macro on such a way that it runs not from the
first record till the last of the sheet, but only for each record that
is activated (=selected). This could be a range or with ctrl-x
selected different ones.

The macro should something like.......
for all selected fields, run the macro for each selected record and if
in column A of this activated record is a "y" registered run another
actionmacro.

Somebody can help me ?

regards,
Johan
 
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
How do I remove all records of duplicated fields? nozzaworld Excel Discussion (Misc queries) 3 February 22nd 10 08:30 PM
Calculated fields in Records Silena K-K Excel Discussion (Misc queries) 1 April 1st 08 08:05 PM
De-Dupe Records Based on Two Fields. onlythebest Excel Discussion (Misc queries) 2 July 17th 06 06:52 PM
Duplicate records with various formats for fields Rbryant Excel Discussion (Misc queries) 1 July 7th 06 12:59 AM
Macro to Export Selected fields to an Existing Access Database ernie Excel Programming 1 March 13th 06 05:01 PM


All times are GMT +1. The time now is 02:13 AM.

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"