Results 1 to 20 of 20

Erow not entering Data in correct row.

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2013
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    36

    Erow not entering Data in correct row.

    Why is this not working. It's showing up on row 30 and not erowing. Should be row 1 then row two..ect.

    Private Sub cmdtranfer_Click()
    'Range("C2").Value = txtname
    'Range("D2").Value = cmbBCCfacility.Value
    'Range("E2").Value = cmbhospital.Value
    'Range("F2").Value = cmbadmitdr.Value
    'Range("G2").Value = cmbHosattend.Value
    'Range("H2").Value = cmbconsult.Value
    'Range("I2").Value = cmbprimary.Value
    'Range("J2").Value = cmbBccAtt.Value
    'Range("K2").Value = cmbassigned.Value
    eRow = Sheet1.Cells(Rows.Count, 1).End(x1Up).Offset(1, 0).Row
    Cells(eRow, 3).Value = txtname.Text
    Cells(eRow, 4).Value = cmbBCCfacility.Value
    Cells(eRow, 5).Value = cmbhospital.Value
    Cells(eRow, 6).Value = cmbadmitdr.Value
    Cells(eRow, 7).Value = cmbHosattend.Value
    Cells(eRow, 8).Value = cmbconsult.Value
    Cells(eRow, 9).Value = cmbprimary.Value
    Cells(eRow, 10).Value = cmbBccAtt.Value
    Cells(eRow, 11).Value = cmbassigned.Value
    Attached Files Attached Files
    Last edited by zbor; 12-10-2013 at 08:23 AM. Reason: compliance

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Question regarding conditional format question that covers two range criteria
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 12:32 PM
  2. Replies: 3
    Last Post: 06-17-2011, 08:09 AM
  3. Two question, numeric code question and subtraction of two columns?
    By mgsweden78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2008, 02:50 AM
  4. macro question and count question... thanks!
    By bstaff in forum Excel General
    Replies: 5
    Last Post: 02-07-2007, 10:12 AM
  5. Replies: 3
    Last Post: 05-05-2006, 12:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1