calculation by vba

[agog12]

vba is placed in a seperate file c.xlsm
both files are located in a same place
there is a file name sample1.xlsx
open sample1.xlsx
in column N we have to use the formula =H2/M2 and paste the result in values in column N of sample1.xlsx
and in coulmn Q we have to use the formula =N2*P2 and paste the result in values in column Q of sample1.xlsx
and save and close the sample1.xlsx


note we have to use the formula till the end of the data (till the column H has data )
example if column H has data till H17 then we have to use the formula till
N17 & Q17

so plz have a look sir and help me in solving this problem by vba macro sir

 

[agog12]

see the link i have posted copy and paste putting details on that post

 

[agog12]

i just posted on copy and paste post plz check sir

 

[MARK858]

It is not the macro causing the issue, it is what you have in the CSV, in the other post you need to explain what is in those cells.

If it is not a formula then use the =CODE(65539) formula in the CSV and tell the people reading it what it returns or if it is text #N/A then you need to tell the readers that.

As you are not willing/able to provide a link to the workbook/CSV then it is up to you to explain what is in those cells as the readers can't do that for you.

I am not replying anymore to this thread. Any info you need to give needs to be put in the other thread.

 

[agog12]

bro give me some time i will let u know all details about where the mistake occurred everything just give some time bro

 

[agog12]

Bro u were right everything is perfect

 

[MARK858]

If you know what the issue is then you need to update the other thread.

 

[agog12]

No issues it is perfect

 

[MARK858]

You need to put a comment there that you have it resolved so that people don't waste any time on it.

 

[agog12]

Problem Solved

 

[agog12]

Problem solved it works perfect