HELP with macro config

If you've forgotten your password, fill out the form on this page: http://edit.yahoo.com/config/eval_forgot...

You'll have to verify security info about your account so that Yahoo can be sure you're the account owner.

Display reads CONFIG RQRD or NTM CONFIG RQD on Stairmaster Equipment Probable Cause The message CONFIG RQRD or NTM CONFIG RQD appears when the console needs to be configured for the machine type it is installed. This message is common when the console has been replaced or if the settings have been changed. Message is commonly seen on various Stairmaster equipment such as bike models 3000CE, 3300CE, 3400CE, 3600RC, 3800RC and 3900RC; stepper models 4400PT, 4600PT, 4400CL, 4600CL and SC916; stepmill models 7000PT and SM916; elliptical model ClubStride 5100.
Corrective Action

• Make sure the unit is in an "idle" state. "Idle" state means the console is not displaying an error or any message that requires data input. The display should basically be freshly powered up, scrolling the EKG or welcome message
• Configure the console for the proper machine type by pressing Level UP, 80, ENTER
• Using the Level UP or Level DOWN keys, scroll through to the proper machine type (Bike, Elliptical, Stairclimber or Stepmill)
• Once the proper machine type is shown on the display select the machine type by pressing ENTER
• This completes the steps necessary when your Stairmaster display reads CONFIG RQRD or NTM CONFIG RQD

Stairmaster Console Message CONFIG RQRD or NTM CONFIG RQD

To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)
This will display N/A# if the number can't be found.

Display reads CONFIG RQRD or NTM CONFIG RQD on Stairmaster Equipment Probable Cause The message CONFIG RQRD or NTM CONFIG RQD appears when the console needs to be configured for the machine type it is installed. This message is common when the console has been replaced or if the settings have been changed. Message is commonly seen on various Stairmaster equipment such as bike models 3000CE, 3300CE, 3400CE, 3600RC, 3800RC and 3900RC; stepper models 4400PT, 4600PT, 4400CL, 4600CL and SC916; stepmill models 7000PT and SM916; elliptical model ClubStride 5100.
Corrective Action

• Make sure the unit is in an "idle" state. "Idle" state means the console is not displaying an error or any message that requires data input. The display should basically be freshly powered up, scrolling the EKG or welcome message
• Configure the console for the proper machine type by pressing Level UP, 80, ENTER
• Using the Level UP or Level DOWN keys, scroll through to the proper machine type (Bike, Elliptical, Stairclimber or Stepmill)
• Once the proper machine type is shown on the display select the machine type by pressing ENTER
• This completes the steps necessary when your Stairmaster display reads CONFIG RQRD or NTM CONFIG RQD

Stairmaster Console Message CONFIG RQRD or NTM CONFIG RQD

Before you can attain your Motorola CLIQ's unlock code you will need the IMEI number on it. You can find the IMEI number by simply typing *#06# and hitting enter. This number is unique to all GSMphone and will help calculate your unlocking code. Once you have your unlock code you are ready to begun the Motorola unlock instructions posted below.

Here are the steps to unlock your phone:
Unlock Motorola CLIQ (SIM Unlock)

1. Reboot your Motorola CLIQ with an unaccepted SIM card in.
*If the display reads "Enter Special Code", enter the unlock code and press "OK"
*If the display does not read "Enter Special code":
2. Press and hold the * key until an entry box is displayed.
3. Type *, #, 3, 2, # and press "OK"
4. Enter your Motorola CLIQ's unlock code and press "OK."
5. Your Motorola CLIQ should now display either "Completed" or "Deleted"

I have not use the internet on my nokia 3110c phone when i start config.setting then personal config. setting, i can not create ADD NEW. when i select the ACCESS POINT then display show me Cannot Add New Account.Memory full.

Menu - Settings - Configuration - Personal config. sett.:

MEdia Net
Account name: MEdia Net
Homepage: http://device.home
Use pref. access pt. : No
Access point settings
Proxy: Enabled
Proxy address: wireless.cingular.com
Proxy port: 80
Data bearer: Packet data
Bearer settings
Packet data acc. pt. : wap.cingular
Network type: IPv6
Authentication type: Normal
User name: [email protected]

My multimedia messages
Account name: My multimedia message
Server address: http://mmsc.cingular.com
Use pref. access pt.: No
Access point setttings
Proxy: Enabled
Proxy address: wireless.cingular.com
Proxy port: 8080
Bearer settings
Packet data acc. pt. : wap.cingular
Network type: IPv4
Authentication type: Normal
User name: [email protected]

Menu - Messaging - Message settings - Multimedia messages - Configuration sett.
Configuration: Personal config.
Account: My multimedia message

There is function called INPUT, which opens an input window and waits for user input. The input is stored in macro cell and you can refer to it later. To get to the end of (or top of) use SELECT.END and you will go from the active cell to the first blank cell up, down, left or right depending on the argument you enter. These are Macro Version 4.0 functions and there are similar functions in VBA RHands

You did not respond to my claification request. Here is some code that might help, it copies a selection of cells going down until an emty cell is found and across until an emty cell is found. This is form an earlier version of office but should comeclose to woring in 2007.

Sub copyrange()
'
' copyrange Macro
' Macro written by Royal 11/22/2008.
'


'save the return values
wksname = ActiveSheet.Name
returncell = ActiveCell.Address
searchfor = ActiveCell.Value

'go to first worksheet and find entered value (note this is a value serach)
Worksheets(1).Activate
findfor = "A1"
On Error Resume Next

findfor = Cells.Find(What:=searchfor, After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
False).Address
If findfor = "A1" Then
erwks = ActiveSheet.Name
Sheets(wksname).Activate
er = MsgBox("Search item not found on Worksheet" + erwks, , "Search Error")
Exit Sub
Else
findfor.Activate
End If

Cells.FindNext(After:=ActiveCell).Activate

'save this address and start searching for copy area boundaries
begcell = ActiveCell.Address
begcl = ActiveCell.Cells.Column
begri = ActiveCell.Cells.Row
'search amaximum of 1000 rows and 676 columns
endri = begri + 1000
endcl = 26 * 26
maxrow = 0
maxcol = 0

For col = Cells.Column To endcl
If Cells(begri, col) = "" Then
maxcol = col
col = endcl
ri = endri
Else
ri = begri
End If
For ri = ri To (Cells.Row + 1000)
If Cells(ri, col) = "" Then
If ri > maxrow Then
maxrow = ri
End If
ri = endri
End If
Next ri
Next col

maxrow = maxrow - 1
maxcol = maxcol - 1

'copy the selected area
endcell = Cells(maxrow, maxcol).Address
crnge = begcell & ":" & endcell
Range(crnge).Select
Selection.Copy
'go back and paste it in
Sheets(wksname).Activate
Range(returncell).Select
' use this if yo want to paste formulas etc.
'ActiveSheet.Paste
' use this code if you want to paste values instead of formulas etc.
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range(returncell).Select

Hi, I was looking to create a timmer. with stop and start option on excel.I have found the anser withyahoo group answers, that was help full and free, i got the VB macro programee. if you still can help me , here is the query,

I need a timer with stop and start option,

when i click on the star button i want the present time coming up on a cell(any cell) and when i click on the stop, i need to get the presen tme on the other cell, i need to clculate the time spent between the 2times.

i also need the time geting accumalated in the different sheet to calculate, how many times i have clicked and the difference.

Thank you for you any help you provide.

Regards

Rochboy