VBA Evaluate Formula and "Copy Down" Result as String/Value to Last Row

**falkon007** · 04-21-2013, 11:25 PM

Hi there,
I have a piece of code which is working beautifully but at 500000 lines it is occasionally causing out of Memory issues when I run some other macros after it because it stores the actual formula in the cell. I wish for the Macro to evaluate the formula in relevant to the row it is in but only paste the value as text in the cell instead of having 6 coloumns * 500000 lines of formula saved in cells:

Here is the code:

Please Login or Register  to view this content.

Is it possible to manipulate this VBA to paste only the values from Row 1 to 500000 down coloumns A to F?

**falkon007** · 04-22-2013, 12:01 AM

In other worlds if I could make coloumn E be:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

So then the contens of E13 would be the result of the formula above ....and the contents of E500000 would be the result of the formula:

=IF(CONCATENATE(C500000,D500000)=""UR"","""",IF(S500000="""","""",S500000)

(I know this isn't a real coding possibility but you may understand what I wish to achieve.)

Cheers,

**JosephP** · 04-22-2013, 03:04 AM

you could try simply entering the formula then converting it to a value. also since you're using 2010 or later you can use IFERROR

Please Login or Register  to view this content.

for example.

VBA Evaluate Formula and "Copy Down" Result as String/Value to Last Row

LinkBack

Thread Tools

Rate This Thread

Display

VBA Evaluate Formula and "Copy Down" Result as String/Value to Last Row

Re: VBA Evaluate Formula and "Copy Down" Result as String/Value to Last Row

Re: VBA Evaluate Formula and "Copy Down" Result as String/Value to Last Row

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions