Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    43

    Thumbs up Unanswered: Function value -> value

    I suspect this has been covered before but I'm not really sure what to search for. Can anyone tell me how I can convert a column of functions to only the actual values the functions return?

  2. #2
    Join Date
    Feb 2006
    Posts
    113
    In essence
    Code:
    Columns("A").value = Columns("A").value
    Though you might want to reduce the range - not the whole column - for speed.

Posting Permissions

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