Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quick question...
Whats the whole..
i = i + 1 thing about, i see it everywhere. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quick question...
NPell;228828 Wrote: Whats the whole.. i = i + 1 thing about, i see it everywhere.Its purely a way of using a variable that will have an incremental number for use in code like Code: -------------------- Range("A" & i).Value = i -------------------- -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63842 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quick question...
NPell;228828 Wrote: Whats the whole.. i = i + 1 thing about, i see it everywhere. I don't think you'll find this kind of formula in Worksheet functions but rather in programming. It's usually increasing a counter by one in a loop and then doing some test on the value Intiliaze counter Start i=i+1 If i ( certain condition) then do sometning Else go back to start -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63842 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quick question...
On Feb 13, 12:57*pm, Simon Lloyd
wrote: NPell;228828 Wrote: Whats the whole.. i = i + 1 thing about, i see it everywhere.Its purely a way of using a variable that will have an incremental number for use in code like Code: -------------------- * * Range("A" & i).Value = i -------------------- -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile:http://www.thecodecage.com/forumz/member.php?userid=1 View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=63842 Thanks guys. I see it in arrays alot. Is it so that i can increase Array 2 along with Array 1? Beacuse thats what im trying to acomplish... See... ------------------------------------ myF1 = Array("T 1", "T 2", "T 3") myF2 = Array("Team 1", "Team 2", "Team 3") For Each F1 In myF1 Workbooks("Test.xls").Activate Workbooks("Test.xls").Sheets("Source_Live").Select Selection.AutoFilter Field:=8, Criteria1:=F2 Selection.AutoFilter Field:=28, Criteria1:="Monthly" Cells.SpecialCells(xlCellTypeVisible).Copy Workbooks ("Template_3P.xls").Sheets(F1 & " Live M").Range("A1") Workbooks("Test.xls").Sheets("Source_Live").ShowAl lData Next F1 ------------------------------------ What do i need to change so that when part A in F1 ("T 1") is active, then part A in F2 is active ("Team 1")???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
quick question | Excel Discussion (Misc queries) | |||
quick question | Excel Discussion (Misc queries) | |||
quick question | Excel Discussion (Misc queries) | |||
Quick Question | Excel Worksheet Functions | |||
Quick Question | Excel Discussion (Misc queries) |