Search results

I never claimed superiority in any sense, and certainly don't think my thought process is superior compared to anyone else's. I simply didn't see logic in an athiest's argument that a supreme force isn't necessary. It's still difficult to wrap my mind around... but it is based on valid logical...

I have a form/query in which people enter various data regarding what is on a pallet. For every item there is a default quantity which is pulled from a table. The quantities all include amounts like "50 lb. bags". I need do do a calculation based of the quantity of the items (IE there are 40...

Actually, it's one of the 7 Habits of Highly Effective People, a wonderful method of sharpening yourself, opening yourself up, and begin to make sense of the endless flow of communication around us. If you seek first to be understood, you try to make your point known before stopping to think...

That would be turning away from God, not to mention breaking multiple Commandments. God does not want us to slaughter each other in His name. God and Jesus are about being in harmony with the universe, not about getting our undies in a bunch. It is fallacious to think that believing in God...

Oh, I do accept evolution. It completely explains how God created what we see all around us today. I find it ridiculously foolish that people science and religion both butt heads when they both explain the same thing, just in different ways. It's not evolution vs. Creation, but rather how...

Nice way to mis-characterize things complete. As a God-fearing man, I view science as explaining the means of God's creation. All science does for me is further prove that there is intelligent design in this universe, and how very miraculous it is. I have a hard time believing that this all...

I am building a placard tool which will be used to identify pallets containing up to 10 different items. I would like for the user to be able to select on a form how many different items will be on the selected pallet before being able to input the data. For instance, if the user inputs "5"...

Hi all, I have a table in which multiple item numbers are stored in the same record. I am trying to build a query in which the item descriptions are pulled from a different table, but can still tie together the item # and the description multiple times on the same record for different item #s...

*Phew* I thought I was going crazy! I tried rebuilding the entire sheet as well from scratch and was still getting the same error. I appreciate Holger's help; I hope he has an idea of what's going on here, because I'm stumped and am not sure how to fix this. The issue comes down to between...

Hi Holger, I don't quite understand what you're getting at. What didn't I care to mention? I've shared everything possible and I'm really trying to learn and understand what's going on. You've been of great assistance to me, so I'm not understanding where you are coming from on that last...

I do seem to have one issue left. When I close out the workbook, I get a runtime error '1004' when a filter has been applied. Upon closing the workbook, I'd like for the filter to be "un-filtered" but not removed completely, so I used a combination of both your code and Brian's code. Here's...

I removed the reverse as advised (it appears to be redundant) but onTime still fails. I'd think that onTime and this function should be able to co-exist together. :/

Well, I added in the following code: ActiveSheet.Unprotect Password:="TNT", UserInterfaceOnly:=True, AllowFiltering:=True and the reverse when the workbook closes: ActiveSheet.Protect Password:="TNT", UserInterfaceOnly:=True, AllowFiltering:=True but this has been causing OnTime to fail. How...

Thank you; that works perfectly!

Thank Holger! A couple of questions: first, it seems to take the AutoFilter off completely. Is there a way to leave the Autofilter on the worksheet but just reset the values to "all" so the filter is active, but the filters applied to the worksheet are removed? Second, is it possible for...

Hi all, You guys have been a huge help with my Excel conundrums the past few days! Is there a way I can use VBA to automatically remove filters on a sheet and have it default the active cell to A1 when a sheet is saved and closed so that the next person to open it sees it "fresh"?

Is it possible for Excel to force quit after a certain period of inactivity? I have a spreadsheet that unfortunately can't be shared due to a couple issues that arise whilst sharing. I'm just concerned that if someone opens the sheet and walks away, they lock out other people who need to...

Thank you! :)

They all return the same value, not different ones.

Hi all, Excel seems to be returning the incorrect result for a few entries on my spreadsheet. We have solme calculations that are run using the INT function, and when something should mathematically be 0, it is returning to us as -1. I've attached the spreadsheet for reference, and the...