+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 19 of 19

VBA code to convert Survey numeric values to words

  1. #16
    Forum Contributor
    Join Date
    05-22-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007
    Posts
    127

    Re: VBA code to convert Survey numeric values to words

    Hi Jindon,

    The file is the same as the one that is attached to my Post #1 of this thread.

    The only problem is that the one-line code that you advised me to change with in your post #13 above does not populate all the relevant columns in Sheet 2 (i.e. Q16 to Summary columns). All that I ask is that your previous code which accurately transferred/coverted everything over to Sheet 2, should leave out transferring Row 1 from Sheet 1. This can be corrected using my original file uploaded in Post #1.

    There is no difference between another copy of the file that I would upload. Your code has already resolved the issue concerning ensuring that the copying over to Sheet 2 should be restricted to Rows 2 to 31. That's working fine. It is just to leave out copying over Row 1.

    I am leaving out the 'dynamic range' issue for now. I can do with not incorporating that at the moment.

    Thanks and sorry for the troubles.

    Newqueen
    Last edited by newqueen; 01-11-2018 at 05:24 PM.

  2. #17
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    11,670

    Re: VBA code to convert Survey numeric values to words

    If the range is fixed, can you just specify the range like

    Please Login or Register  to view this content.
    If you change A2, the other one should be changed, too.

  3. #18
    Forum Contributor
    Join Date
    05-22-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007
    Posts
    127

    Re: VBA code to convert Survey numeric values to words

    Thanks very much Jindon. Your suggestion in post #17 is exactly what I needed. That was very kind of you, and I appreciate your patience with me.

    Newqueen

  4. #19
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    11,670

    Re: VBA code to convert Survey numeric values to words

    You are welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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