Recent content by mrtauntaun

That is just a brilliant piece of code. Thanks Skip!

How can I make a macro fire when I double click for the drill down? I tried recording a macro to try and replicate it, but I don't know how to trigger it.

I love pivot tables. I love the option where if you double click in one of the cells it drills down to show you records. My question is, how do I change the font size of the records you see from the drill down? I have a lot of data there, and I want to make it smaller so more fits on the...

I am importing an excel spreadsheet every month into one of my DBs. One of the fields can (but not always, and not even frequently) contain data with multiple values. These values are user IDs and are seperated by a semicolon. I need to analyze each of these IDs individually, but when I run...

Hi all. I have a long macro (running from excel) that runs every night running a variety of reports out of an access database for me. The last thing I want the database to do is to compact. I know there is a command line you can use with the /compact option, but I can't figure out how to run...

Also, this spreadsheet will be generated daily, based on a criteria of code. So I can't set it every day by hand, which is why I wanted to use code. Is there a VBA alternative?

That's cool. To take this a step further, what if I wanted it to check a range of cells? Say, AD2 through AD10?

Hi all. I am looking to do the following: If AD2 = 0 then 'Fill row 2 with color(red)' Either the entire row or a selection of cells in that row, whichever is easier. I've googled like crazy, but I can't find this command. Thanks!

I have several rows hidden in a spreadsheet. I want to use the autofilter on the displayed data only, however wheneven I make a selection with the filter, it unhides all hidden rows. Is there anyway to keep the hidden rows hidden? Doing so in VBA would be ideal, but i'll take anything at this...

Hi guys. And here I thought Math not Zathras skill :) Fireftyr, originally I did not need it to loop. Just to perform a simple formula. However, I have since been asked to add a lot of new criteria to the calculation. Also, it is the result of that formula that needs the if, not just if it...

Awesome, that did it. I love tektips. Thanks Rofeu!

Hi all. I am using the following bit of code: Dim rngCalc As Range Set rngCalc = Range("AD2:AD" & Cells(Rows.Count,1).End(xlUp).Row) rngCalc.Formula = "=(8-K2)" rngCalc.Value = rngCalc.Value In this case, the first cell to be replaced is AD2 and it continues for as many rows as I have. What...

Thank you both! Both codes work, though I am going with firefytrs code as its more compact, thanks again!

Hi there. Im new to using VBA in excel, so bear with me. I have a workshet with numerous rows. I need to make a snipet of code that checks a row, takes the values from a cell, runs it through a formula, and puts it in a cell at the end of a row. Once it is done, the have it do so for the next...

Its not that simple unfortunately. It's not my DB, and this is the way it needs to be done for a vareity of reasons. I do understand your point however, and the DB DOES compact and repair itself daily after these tasks are done.