LinkBack URL
About LinkBacks
Any help would be appreciated
Please Login or Register to view this content.
Any help would be appreciated
Please Login or Register to view this content.
Last edited by emptycucumber; 05-18-2009 at 10:05 PM.
Hi emptycucumber,
Welcome to the forum and thanks for fixing up your post.
Post back re how the following goes:
HTHPlease Login or Register to view this content.
Robert
Last edited by Trebor76; 05-18-2009 at 10:39 PM.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
OMG!!! AMAZING
Thank you so much. You cleaned up the code so nicely too.
Works perfect!
QUESTION: How would I go about writing a code to delete the contents of a cell?
Last edited by emptycucumber; 05-18-2009 at 11:54 PM.
To fix the original code:
where the numbers in [] are the offsets from the selected cell.Please Login or Register to view this content.
& RC[-8] = R[]C[-8]; references a cell in the same row as the selected cell.
Last edited by protonLeah; 05-19-2009 at 12:24 AM.
Ben Van Johnson
Hi emptycucumber,
Glad it worked
The following will delete all contents within cell A5...
...while the following will delete all contents from the range A5:B10:Please Login or Register to view this content.
HTHPlease Login or Register to view this content.
Robert
LOL! I was about to ask you that question, but I figured it out on my own.Works!
Hmm, actually I would prefer to make the cell value "0". How would I do that?
Range("D4").Value something?
I'm a beginner, so excuse meThanks for the help!
Last edited by emptycucumber; 05-19-2009 at 01:02 AM.
You're welcome
How do I include a logical value?
IF undeveloped=4 Range("undeveloped").Value = Evaluate("=undeveloped-4")Sub Shipping_Company()
Range("shipping").Value = Evaluate("=shipping+1")
Range("undeveloped").Value = Evaluate("=undeveloped-4")
End Sub
IF undeveloped=3 Range("undeveloped").Value = Evaluate("=undeveloped-3")
etc etc, of course I'd clean up the code. I just need to know how to structure it.
Hi there,
You should really start a new thread for each separate query.
That said, I'm not sure how many arguments you're referring to when you say "etc etc" but I think the following may be what you're after:
HTHPlease Login or Register to view this content.
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks