0

Hello,

I have a layout and i have to paste information on that layout, in that lay i have Columns H, P

i have a formula in column P like this

=IF(ISERROR(P3/H3),0,P3/H3)

but when i insert the information obtained in VBN to EXCEL worksheet it pastes the information just fine, the only problem is that the formula above is erased.

I want to know how can I paste that formula and leave it into the excel worksheet when the file is being saved in VBN.

i tried using this

For row As Integer = 2 To 239
    exlWsh.Cells(row, 17) = "=IF(ISERROR(P" + row + "/H" + row + "),0,P" + row + "/H" + row + ")"

Next

the reason why i am using this is because i have 238 columns where the formula has to be pasted, in Column H there is no data, that data is gonna be pasted manually after this file is generated, but i want to leave that formula there when they paste the information on Column H.

Any help would be appreciated, thanks in advance.

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by darkelflemurian
0

hi darkelflemurian, have you tried pasting the VBN data first then after that apply the formula. check if it works :)

0

hi darkelflemurian, have you tried pasting the VBN data first then after that apply the formula. check if it works :)

I'll give it a try and let you know if it worked, thanks

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.