VBA Cell Value is equal to value of a cell with a formula

[MICowboy13]

Hi all,

Quick question, I have a VBA that loops through worksheets and based on a condition adds a new worksheet and copies and pastes a few values. However, the calling of the values to a new cell is not working and I'm not sure why. Could it be because the Range value is actually a formula (I want just the value to appear in the new worksheet)? The following is what is not working;

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Should I replace the top code with a specific copy and paste special?

Any help would be appreciated, I hope this is enough information for someone to tell me what is going on.


Thank You!

[ranman256]

even if its a formula, it will resolve to the value.
the only way to see the formula is range(xxx).formula

you can put a break line (F9) on a code line, then when it stops, hover the cursor over it and it will tell the value.

[stnkynts]

Are you properly identifying the worksheet on both sides of the equation.

e.g. Worksheet.Cells.Value = Worksheet.Range.Value

[MICowboy13]

Ranman,

Thanks for the tip, I should have done that before. Turns out the correct values were there but a 2nd part of the code was deleting what was there.

I appreciate your input!