View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
stevem[_3_] stevem[_3_] is offline
external usenet poster
 
Posts: 1
Default Finding Column based on input, then first empty row

Great, works..

Once I changed it to
ActiveCell.offset(1,0)= CDbl(tbScore)

Thanks for all the help, and hope you feel better soon.

On a side note, notice you're in Biloxi .. used to live there myself
YEARS ago .. (as in 1992-93)


Charles wrote:
*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/