Consulting

Results 1 to 3 of 3

Thread: VBA Set cell value under last row

  1. 07-29-2013, 12:40 AM #1
    winstonhuxle
    winstonhuxle is offline
    VBAX Regular
    Joined
    Jul 2013
    Posts
    19
    Location

    VBA Set cell value under last row

    Hello, I need to set a cell value in column A, under last row with data. Could you help please? Thanks
    Reply With Quote Reply With Quote
  2. 07-29-2013, 02:16 AM #2
    patel
    patel is offline
    VBAX Mentor
    Joined
    Jul 2012
    Posts
    398
    Location
    LR = Cells(Rows.Count, "A").End(xlUp).Row+1
range("A" & LR).value = yourvalue
    Reply With Quote Reply With Quote
  3. 07-29-2013, 05:24 AM #3
    winstonhuxle
    winstonhuxle is offline
    VBAX Regular
    Joined
    Jul 2013
    Posts
    19
    Location
    Perfect. Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules