LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Trying a macro on excel

I need to do a filter of sorts using the color of the rows as the basis for
this filter. i am working on a "For" loop that should go row by row and
checking to see if the row color is "no fill" if it is it should cut it and
paste it on another workbook i have already made. i can select the work book
and all but i don't know how o check the row color (was thinking of checking
the cell (A(i)) wher i is the number in the for loop and using a similar
method for the cutting and pasting of the rows. how can i do it. i'll post
what code i have so you see what i'm working with.

PS i am very rusty with my VB coding so please be understanding if the code
is mostly wrong... :)

Sub Test4()
Dim i as integer
Dim pos as integer
pos =1
For i=3 to 7215
Windows("DE.xls").Activate
Range("A"+i).Select //this is where i can't get it to work
if (Selection.Interior.Color = xlNone) then // don't know if this is
right
Rows(""+ i":"+i"").Select
Selection.Cut
Windows("test.xls").Activate
Rows(""+pos":"+pos"").Select //how should i do this
ActiveSheet.Paste
pos= pos+1
end If
next i
 
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
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 1 February 5th 07 09:31 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 3 February 5th 07 08:22 PM
passing arguments from an excel macro to a word macro KWE39 Excel Discussion (Misc queries) 1 July 7th 05 03:56 PM
Macro - Open Word with Excel macro Bill Excel Discussion (Misc queries) 3 May 23rd 05 11:21 PM
after creating macro button, closed excel then restarted excel hjd43 Excel Discussion (Misc queries) 1 March 3rd 05 03:04 AM


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