Hi
Do You want this , My Maths is not so good but I think it will generate 9^9
Unique Id Number for you.
Sub ss()
For One = 1 To 9
For Two = 1 To 9
For three = 1 To 9
For Four = 1 To 9
For Five = 1 To 9
For Six = 1 To 9
For Seven = 1 To 9
For Eight = 1 To 9
For Nine = 1 To 9
ActiveCell.Value = One & Two & three &
Four & Five & Six & Seven & Eight & Nine
If ActiveCell.Row <> 1048576 Then
ActiveCell.Offset(1, 0).Select
Else
ActiveCell.Offset(1, 1).Select
End If
Next
Next
Next
Next
Next
Next
Next
Next
Next
End Sub
-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of [email protected]
Sent: Saturday, July 23, 2011 1:11 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ LINEST
I'm trying to utilize a series of data to execute multiple Linests.
I have 10 columns of data of equal length.
The first 9 columns represent 'x-value' candidates
The 10th column represents 'y-value'
I'd like to create linests that utilize each potential unique
variation of each of the first 9 columns
Cell 1 = linest (column 10; column 1,2,3,4,5,6,7,8,9)
Cell 2 = linest (column 10; column 1,2,3,4,5,6,7,8)
.
.
.
Cell 10 = linest(column 10, column 2,3,4,5,6,7,8,9)
Cell 11 = linest(column 10, column 1,2,3,4,5,6,7,9) <----contiguous
column 8 excluded
Cell 12 = linest (column 10, column 1,2,3,4,5,6,8,9)
etc.
How do I get Linest to accept the non-contiguous columns?
Thanks in advance
Marston
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
