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

 

[MARK858]

Are you sure that you don't have any formula in H65537?

=CODE(H65537 ) RESULT # N/A

The above is a bit of a strange answer, are you sure that #N/A is the result of that formula?

 

[agog12]

yes

 

[MARK858]

yes

To which of the 2 questions? and the answer to the other question?

 

[agog12]

bro vba code issue is there plz remake the code as pef condition i think it will work

 

[MARK858]

Until we work out what the issue is we can't rewrite code. Answer the questions as asked please.

 

[agog12]

macro depend on how much data column H has if column H has data till H20 then we we have to paste the formula till N20 &Q20 and convert that into value but what this code is doing it is pasting in a complete column got it bro

 

[MARK858]

Yes, we already got that but it is not helping. We need to work out what is causing the last row to be incorrect.
Are there any formulas in column H (including the cells with data)?

 

[agog12]

bro after H20 there is no data in it nor columnA nor column B Nor ColumnC not in any column and if we put the formula then it will return an error
and i want to inform u that now data is there till H20 and infuture it can be more also

 

[MARK858]

We are going around in circles, please answer the questions asked and nothing else please.
The last question asked was

Are there any formulas in column H (including the cells with data)?

 

[agog12]

no i have not use any formula in column H i have used formula in column I