Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Column based on input, then first empty row
stevem,
Sorry been under the weather. Try this if you want the score to be placed in cell a2 Application.ScreenUpdating = False Sheets("Light Class").Activate With frmPilot On Error Resume Next Cells.Find(What:=cbName.Text, lookat:=xlPart).Select With ActiveCell End(xlDown).Offset(1, 0).Select End With ActiveCell.offset(0,1)= CDbl(tbScore) <<<<<<<make change here End With Sheets("Master").Activate Application.ScreenUpdating = True HTH Charles --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
Finding a record based on user input | Excel Discussion (Misc queries) | |||
Autofill Column D based on input in Column C | Excel Discussion (Misc queries) | |||
Finding last non-empty column in row... | Excel Programming |