Alternative to insert

M

mikewild2000

I have the following code in a shared file, and i keep running into
errors with the insert code.

If scoreRow <> x Then
ws1.Cells(scoreRow, 11).Cut
ws1.Cells(x, 11).Insert
ws1.Cells(scoreRow, 12).Cut
ws1.Cells(x, 12).Insert
End If

Q. Is there an alternative way to carry out the above procedure in a
shared file.

Thanks for any help.
 
T

Tom Ogilvy

In the help on Limitations of Shared workbooks, it says

"You can't insert or delete blocks of cells"

as a workaround it suggests:

" You can insert entire rows and columns."
 
M

mikewild2000

tom,

I'm struggling to find an easy way to select then entire row b
adjusting the code i already have.

Where do i start
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top