select range of cells and replace

Hi,

I have wrote th below, but it only selects the last column, rather than all 5 i though it would - what am i missing?

thanks

Antony

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

In place of those first 5 lines of code. That presumes there are blank cells around the data you're copying.

The following will select N2 and the five columns to the right of N2 or N2:S2

Please Login or Register  to view this content.

in order to avoid the wrath of a moderator please edit your first post to surround your code with code tags
Looks like my warning came a little too late

this will select all the cells in columns N:S apart from row 1

Please Login or Register  to view this content.

providing that col n has no missing values

Please Login or Register  to view this content.

this will do the replace u wanted




ahh my bad this works

Please Login or Register  to view this content.

the way i under stand it is in cols N:S
there are cells with nothing in and cells with data in
is this correct??

if otherwise could you provide an example?