Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter data in next empty row after cell name
I need some help entering data from a form. I have the sheet activaced and
want to select the next row after a paticular name and past information from that cell. I hope this is clear: Here is what i have. Private Sub cmdAdd_Click() Dim iRow As Long Dim LastRow As Object Set ws = ThisWorkbook.ActiveSheet() Set LastRow = ws.Range("a65536").End(xlUp) LastRow.Offset(1, 0).Value = txtCust.Text LastRow.Offset(1, 1).Value = txtService.Text LastRow.Offset(1, 2).Value = txtCircuit.Text Thanks -mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup if #N/A then enter enter data in cell I4 | Excel Discussion (Misc queries) | |||
How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
Not allowing users to enter data into certain cells if another cell is empty | Excel Programming | |||
When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) |