Optimisation of code

Please Login or Register  to view this content.

I have this as part of a bigger macro. Is there a quicker method to setting the titles to the first row of columns other than having the macro select each cell then add the text as shown?

Try this:

Please Login or Register  to view this content.

Does that help?

You can store the values in an Array if you find it easier to adapt in that manner, eg:

Please Login or Register  to view this content.

In VBA you rarely need to .Select anything - doing so will slow your code.

Another way

Please Login or Register  to view this content.