Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 76
Default Quick question...

Whats the whole..
i = i + 1
thing about, i see it everywhere.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 76
Default 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
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
quick question Fady Excel Discussion (Misc queries) 7 February 23rd 08 05:59 AM
quick question riggi Excel Discussion (Misc queries) 4 January 31st 07 07:11 AM
quick question tmela Excel Discussion (Misc queries) 2 August 19th 06 02:56 AM
Quick Question Nikki Excel Worksheet Functions 4 January 31st 06 03:51 PM
Quick Question Jenn Excel Discussion (Misc queries) 2 November 1st 05 10:20 PM


All times are GMT +1. The time now is 10:42 AM.

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"