i have the following code that works fine as a macro. however when it is put into a button click event, it fails. can someone look at my code to see what the problem is?
it fails initially on this line: Sheets("estimating1").Range("a1:i330").Select. The error is "Run time 1004, application defined or object defined error
my code
Please Login or Register to view this content.
Instead of selecting worksheets it is better to refer to the cell directly
For example:
In these two lines
You can use this line directly without select methodPlease Login or Register to view this content.
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
but it fails on this one line: Sheets("estimating1").Range("a1").Paste
that is fully sourced, isn't it?
Last edited by dmcgov; 03-18-2016 at 11:26 AM.
I have told you not to depend on Select method
Would bePlease Login or Register to view this content.
Please Login or Register to view this content.
so this is fully sourced. am i not typing this in correctly?
Sheets("estimating1").Range("a1").Paste
is that a valid command?
duplicate post
Try your modification and if encountered errors try to edit the yellow lines after clicking Debug
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks