Hi this is really starting to annoy me now. Everytime I try to select a column in VBA I get runtime error 1004 "Select method of range class faailed" I'm sure I'm just being an idiot but nothing seems work. I've tried different versions of the same thing but they don't work. Am i doing something really stupid? I've included my code just in case. Thanks.
Please Login or Register to view this content.
use Range instead of Columns. ;-)
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks for replying but same problem.
Oh-your code is in a worksheet module so if you refer to Range or Columns without specifying a worksheet it refers to the sheet containing the code and you can't select anything on that sheet unless it is active.
Please Login or Register to view this content.
Told you I was stupid!does that make a difference?
what - being stupid? :-P
hehehe cheers. I REALLY appreciate that (and the houmour!) Thanks for your help.
Its orking great appart from it dosn't seem to put the formula into column D
I need the formula =c2-today()-182 to be in cells D2 down to last used row but increasing c2 like dragging right corner. Any ideas?Please Login or Register to view this content.
sorry - could not resist!
change the last 3 lines to
Please Login or Register to view this content.
sorry? I've currently got
which puts the formula into d1 and d2 but thats all.Please Login or Register to view this content.
in that case you have the wrong sheet active when this runs
change that toPlease Login or Register to view this content.
or betterPlease Login or Register to view this content.
Please Login or Register to view this content.
You genius!!!!! Thanks thats brilliant. I can now get the main part done from there. Thank you again.
glad to be of service.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks