I can't see how the date would get pasted but the code would still fail on that line. Did you alter the lines directly after that line? I noticed they also have the activecell property on both sides of the equal sign.
I can't see how the date would get pasted but the code would still fail on that line. Did you alter the lines directly after that line? I noticed they also have the activecell property on both sides of the equal sign.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Yes, I changed them as follows;Thanks for taking the time to look at this by the way.![]()
ActiveCell.Value = Sheets("CoA").Range(CellAddress).Value ActiveCell.Offset(0, 1) = Sheets("CoA").Range(CellAddress).Offset(0, 2).Value ActiveCell.Offset(0, 2) = Sheets("CoA").Range(CellAddress).Offset(0, 3).Value ActiveCell.Offset(0, 3) = Sheets("CoA").Range(CellAddress)(0, 5).Value ActiveCell.Offset(0, 4) = Sheets("CoA").Range(CellAddress).Offset(0, 4).Value ActiveCell.Offset(0, 10) = Sheets("CoA").Range(CellAddress).Offset(0, 6).Value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks