Recent content by Eugene99

Doc, I just re-read your post. My formula won't work if you want the results to change with the filters. Glenn's solution will work... Eugene

Doc, Try This: =COUNTIF(Data!F:F,"Yes")/(COUNTA(Data!F:F)-1) Filters will not change the formula's results. Eugene

Try selecting a cell and hitting F2. It should place the cursor on the right side of the last character. Then hit Home. It should place the cursor on the left side of the first character. This will tell you if you have any spaces. Also, when you hit Find, make sure that you do not have a...

Bill, Once you have stopped recording, hit "Alt F11" and go into the VBA Editor. You should have the Project Explorer on the left side of the window. To get the Project Explorer if you do not have it showing, hit "Ctrl-r". Click on the Modules folder and then click on Module1. You should...

Thanks for the info. If this works out, I think I'll ditch Word and get some real web design software... It'll work for now... Eugene

I'm venturing into unfamiliar territory by creating web pages in Word. I created them with the Web Page Wizard, but I have not been able to figure out how to make the hyperlinks change either color or become bold when you hover the mouse over them. Is it possible to do this in Word, or only...

Johnny42, I'm assuming you are importing your CSV file to Excel. Use the Macro Recorder to record your code while you are opening your CSV file. Go to "File", "Open", and select either "All Files (*.*)" or "Text Files (*.prn;*.txt;*.csv)" from the drop down arrow in the "Files of Type:"...

Elizabeth, This will work for you: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim curtime As String, DTSaved As String curtime = Now() DTSaved = curtime With ActiveSheet.PageSetup .RightHeader = DTSaved End With End Sub Vr...

Tiggertoo, Go to Edit, Links, and choose Change Source. Browse for the workbook you are currently in. The links are changed to the workbook that you are currently working in. In other words, the external links now become internal links. Another thing you can do is go to Tools, Options, and...

K8277, You can put a custom button in your tool bar and then assign a macro to this new button. That way, your macro in your personal.xls will run in any workbook that you have open. I use it all the time. Right click in the tool bar area at the top of Excel, choose Customize, drag a button...