566 reputation
37
bio website
location
age 31
visits member for 2 years, 6 months
seen Jan 15 at 21:11

Oct
26
answered Display vs Value in a Microsoft Access Form's dropdown box
Oct
26
comment Close an excel file automatically
The only way I can think to do this is to keep track of when the workbook was last used by setting a variable for basically any event... and then using Application.Ontime to have a sub that checks the date in the variable to see if it was last updated 5 or more minutes ago. This solution is far too involved for me to be willing to write it for you though...
Oct
22
comment Automation for filling in sets of numbers in each row
If you're going to do it this way, you actually only have to fill in the first 2 cells. :)
Oct
19
comment Is there an Excel “missing value” or “NA” symbol?
I think the closest thing is using an empty string... but perhaps someone will surprise me.
Oct
19
comment 'Subscript out of range' error when selecting a range
I was sure that you would eventually do something else. You just didn't share that part. I hope you get the rest working without problems.
Oct
18
answered Find a Certain Cell based on other Cells in Excel/Calc
Oct
18
awarded  Commentator
Oct
18
comment 'Subscript out of range' error when selecting a range
FYI: If your question is specifically about code you have written, (like this one) you will get a broader audience willing and able to answer by asking on Stack Overflow instead of Super User.
Oct
18
answered 'Subscript out of range' error when selecting a range
Oct
16
comment Find a range of cells with a MATCH
If you want to avoid doing things manually, how can you avoid vba? PivotTables are pretty simple.
Oct
10
awarded  Citizen Patrol
Oct
6
awarded  Critic
Oct
4
answered Delete all rows or columns if meeting all multiple conditions
Oct
2
revised MS Excel: How to work with a column chosen by value in header (row1)
added 99 characters in body
Oct
2
comment MS Excel: How to work with a column chosen by value in header (row1)
+1 for being a complicated enough that I had to look at it for a few minutes to figure out why it worked.
Oct
2
answered MS Excel: How to work with a column chosen by value in header (row1)
Oct
2
comment How can I write an excel formula to do row based calculations; where certain conditions need to be met?
It sounds like you want to use SUMIF. Something like SUMIF(B:B,"P3",C:C) would add the columns in column C where the corresponding row in Column B = "P3"
Sep
25
comment run vb6 application (.exe) on windows startup with out login
This may solve your issue: Running Batch File in BackGround when Windows Boots UP
Sep
19
comment In Microsoft Access how do you delete all values in a single column without deleting the entire field.
@allquixotic FYI: Doing that with a table actually asks if you want to delete the fields (which means remove them from the table all together). Doing the same thing in a query just has no affect.
Sep
19
answered In Microsoft Access how do you delete all values in a single column without deleting the entire field.