+ Reply to Thread
Results 1 to 4 of 4

VBA Problem: How to call the last number typed in each line but in different columns

Hybrid View

Guilherme.Cristofoli VBA Problem: How to call the... 08-18-2020, 05:04 PM
6StringJazzer Re: VBA Problem: How to call... 08-18-2020, 07:52 PM
Guilherme.Cristofoli Re: VBA Problem: How to call... 08-19-2020, 07:33 AM
6StringJazzer Re: VBA Problem: How to call... 08-19-2020, 10:27 AM
  1. 08-18-2020, 07:52 PM #1
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: VBA Problem: How to call the last number typed in each line but in different columns

    Is there any reason you want to do this with VBA? If you put this formula in column H you won't need VBA:

    Formula: copy to clipboard 
    =LOOKUP(2,1/(B2:F2<>""),B2:F2)


    Copy down.
    Reply With QuoteRegister To Reply
  2. 08-19-2020, 07:33 AM #2
    Guilherme.Cristofoli is offline
    Registered User
    Join Date
    04-13-2020
    Location
    Brazil
    MS-Off Ver
    MS Office
    Posts
    6

    Thumbs up Re: VBA Problem: How to call the last number typed in each line but in different columns

    Man! You saved me! Thank you very much!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to count number of blank cells on a column up to a number value is typed
    By carlosnixon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-25-2018, 02:46 AM
  2. how to count number of blank cells on a column up to a number value is typed
    By carlosnixon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-25-2018, 01:01 AM
  3. [SOLVED] Typed data convert to columns
    By makinmomb in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-03-2015, 01:13 AM
  4. [SOLVED] Converting an avg value to a whole number next to the avg as if it were typed in.
    By Steve113 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2013, 10:35 PM
  5. [SOLVED] Is there a maximum number of columns available to put into a line graph?
    By Luch in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 09-18-2012, 12:52 PM
  6. Specify range of cells including spaces, manually typed text and line breaks in VBA
    By LindaABH in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2012, 12:59 AM
  7. [SOLVED] toolbar line see what you have typed
    By Tinkerbell in forum Excel General
    Replies: 2
    Last Post: 10-28-2005, 10:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1