Hello I have a spreadsheet that tracks the progress of projects. is there a way to copy only the rows that contains my name (Column G), to a new sheetthat I...

I have a userform to input some data. After the user presses the "enter" button, the data is recorded. I've been asked to have an indicator that flashes for...

Using Excel 2003 I have entered the following formula: =today() & " Net" I want the result to be : 4/7/09 Net , but I keep getting : 39910 Net Any...

I need a formula when the worksheet come up just three question shows. but when the last question is asked and it is a true statement I would like excell to...

I need to create a match-up formula that returns the value from another column. I have 2 cloumns (trailer numbers and their corresponding commodity), and I...

Is it possible to disable all code in all Worbooks including Personal.xls and VBA Add-ins? I know I can disable macros in workbooks upon opening them based...

I have a range variable. I want to print its value to the Immediate Window upon selection of it. Currently I use this to do so: var1 = Target Debug.Print...

Hi All, is there a way to highlight a whole row in a certain color (instead of a single cell) by using conditional formatting? As far as I can see it only...

We have a need to programmatically hide some objects in Excel. We can do it in PowerPoint because it is easy to define the slide number and object number....

Does anyone know a more efficient way to write this code...as I will be checking 50k+ rows Sub Tester() X = 2 Do While X < 9 Dept_Checker =...

I am exporting from Access to Excel and ending up with a single quote in front of the dates--which makes them a text field. This matters because I am using...

I'm working on an Excel VBA project. I'm trying to interface with another developer doing another part of the application. Since they did some testing in...

I'm trying to do something that seems simple but I can't get it to do what I want. I query the user for 3 pieces of information using 3 comboxes. The userform...

I have a workbook that will be shared that contains several worksheets. Depending on the user, I want different sheets hidden from view upon opening the...

Hi, I am trying to make several worksheets ' fiddle proof'. I have sheets that contain macros which will unlock the worksheets, perform the calculation...

I would like to replace the 'a1' with a String variable I have defined earlier in the script in the following...

Has anyone had success with creating custom error bars in Excel 2007 from VBA? In prior versions I was able to do so with ...

Morning all. I just received an error while trying to run a macro. While this is the first time I've operated on this workbook, I did check the information...

I have a spreadsheet that has information for several different divisions on one sheet. Column F specifies which division that row of information (DivE1,...

Excel XP & Win XP I wrote a large program for an OP in which, among other things, a specific range is chosen, from many, to be displayed on the screen. I use...