Improving existing VBA code and removal of unwanted row

[Narasimharao Nandula]

Dear All,

I have managed to make a code for one of our local requirement and it works. I have bunch of different formula's in the row 8 of the sheet between "A:E" and "G:FD" which are connected to several independent sheets. My requirement is of copy of each formula (between "A:E" and "G:FD") till last row of Column "F". Column F data is copied from some other sheet. So that data should not get disturbed.

However there are 2 problems in the code which are defined below:

1) Code is very slow when no. of rows in the sheet are more than 200, no of rows some times go to the tune of 20,000.
2) Code creates last row with blank values. I tried my best to remove this row with the code but could not succeed.

Kindly suggest corrections and faster execution of the code.

Look forward for the advise.

best regards,
Narasimharao

Please Login or Register  to view this content.

[AB33]

Untested.

Please Login or Register  to view this content.

[Narasimharao Nandula]

Hi AB33

Once again thank you for prompt reply. I could use above code. in column F data is from F8. So when i use the code, 7 additional rows are created. Bold letter portion "F" needs corrections. Could you please suggest alternatives?

Thanks again.
Narasimharao

Please Login or Register  to view this content.

[Narasimharao Nandula]

Hi AB33

I have managed to correct the code. THank you once again for your support and i am very happy for your continuous support again and again. Really my knowledge is improved with your support.

Best Regards,
Narasimharao

Corrected code is as follows:

Please Login or Register  to view this content.

[AB33]

Narasimharao,
Well done!
Yes, I forget to deduct the first 7 rows as my rows count goes from 1 to the bottom.