+ Reply to Thread
Results 1 to 3 of 3

Using VBA to create list of calculated values

  1. #1
    Forum Contributor
    Join Date
    04-27-2009
    Location
    Dallas, TX
    MS-Off Ver
    Office 365
    Posts
    215

    Using VBA to create list of calculated values

    Why is this macro not displaying any results???

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,176

    Re: Using VBA to create list of calculated values

    if Range("F6").Value is empty, then nothing will show anywhere.
    tho if it does have a value, all cells in col 19 should be setting to it.

  3. #3
    Forum Contributor
    Join Date
    04-27-2009
    Location
    Dallas, TX
    MS-Off Ver
    Office 365
    Posts
    215

    Re: Using VBA to create list of calculated values

    I just realized that I had my column and row values backwards. lol so the results were being entered off screen. it wasn't until I added ws.cells(r,19).select that it took me to where the data was being entered.

    Sorry for the false alarm.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-14-2012, 01:17 PM
  2. have a drop down list with associated values difference to be calculated
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2012, 05:11 PM
  3. List of values, need calculated after applying 20%
    By yakabod in forum Excel General
    Replies: 3
    Last Post: 05-08-2012, 01:59 PM
  4. Create Daily Log of Calculated Values
    By snoproyoder in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-15-2011, 01:26 PM
  5. Create Chart with calculated cell values
    By JosephPraboi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-30-2009, 09:49 AM
  6. Replies: 6
    Last Post: 12-05-2006, 05:33 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