VBA to copy formulas in column

Dear Friends,

I have formulas from Colum B: BD. These formula start from B6:BD6.

I need to create a button in the sheet so that it copies the formula in row B6:BD6 to all the row till B5000:BD5000.

Kindly help me with the code.

.

Please Login or Register  to view this content.

Hi Logit, thanks for the code.

The code is working and giving the desired result in unprotected sheet. But if I protect the sheet, the code is not working. Please advice how to make the code work in protected sheet.

.
You will need to temporarily 'unprotect' the sheet ... perform your actions ... then protect the sheet again.

The sheet is developed for other users. It need to be protected before I email them. Cannot even share password with them. So kindly suggest any alternate solution, if possible.

Thanks Again.

.
I am not familiar with any other method. Perhaps someone else has a suggestion.

Here are a couple of points ... the macro takes well less than one second to fill the sheet. Here is a modified version of the
macro you can run there to obtain the same results :

Please Login or Register  to view this content.

Less than a second is not sufficient time for anyone to do anything. Were someone desirous of breaking into
the code and / or modifying the formulas, having the sheet in protected status is not going to hinder them.
Excel has long been well known for its lack of security. The built-in password measures are so weak as to render
them truly useless. Only the absolute 'straight and narrow / purer than white snow' person is affected by the
built-in security measures. The Internet is laden with numerous methods of circumventing all of the security
measures contained within Excel ... as well as commercial add-ons that purport to provide a higher level of
security.

Having said that, I understand it may be a company policy that everything is to be password protected. And that
is fine .... but, it won't keep the interested party from getting what they want.

I wish I had an answer for you as I understand your desire to protect the workbook.