Recent content by hobman

Skip, That was exactly what I was looking for. Thanks much to both of you. H.

man, you are pretty good at this. yes, the only problems with your latest code is that 1. what you mentioned above (doesn't ignore blank cells) 2. it applies "pasteSpecial" to the answer (hard codes it) I think I will continue looking into this so I can manupilate what you gave me. thanks...

yeah, there might be. I was hoping that I have numbers in the following ways: Row 1 Column Title Row 2 5.0% Row 3 1.0% Row 4 (completely blank) Row 5 .01% Row 6 .02% Row 7 1.0% Row 8 (Product Formula) What I wanted was, when I run the macro after clicking in row 8, for it to grab the rows...

thanks for the reply skip. Your formula also covers just the specified amount of cells. I was hoping to find a way for it to not just do "-6" always but to grab all cells above active cell which have values in them (non-blank). thanks for your help. H.

I've created a macro and assigned it a hotKey for the Product formula (=product(1+C5:C10)-1). The macro works fine but the short coming is that, the range that it selects is the range I selected when I recorded the macro. So in the above example, it would only select rows C5-C10. The way...

I just got it, thanks anyways.

Thank you so much MajP. not to sound stupid but I was wondering, where should the password be? thanks again.

Sorry but I can't use the search feature since it is out of service right now. Is there a way I can password protect a specific tab on a Form? thanks in advance

Thank you so much PHV, you really deserved TipMaster of the Week award. Thanks again

Thanks for the quick reply PHV. I'm not exactly sure in what way you recommended using the default value property control. I can't just specify one name to show up as a default because there are many employees. Each employee will be entering data for many days at a time and I just want their...

I really need your help. I have a form that is used as a time tracker. 1.Employees select their name from a drop down combo box (cboName) 2.Click on a drop down to select date (cboDate) AND 3.Enter the hours for the day (txtDate) Employees would enter their hours for a month or so at a...

Thanks PHV, that's that's the name I was looking for!

Hi, I am new to this and wondering how I can accomplish the following. I have Initials for employees, I also have categories of work they have done I want to display it like this: Category Total hrs HGB AKA JFK Dish 50 20 10 20 burger 20...

Hi, I am kind of new to this game. I created a site bases on php. I have a "Top.php", "Bottom.php", "Left.php", "right.php" and a "middle.php" put in a "index.php". The problem I am having is that, the website does not show up right on diffrent computers. I played with the table sizes so...

I know this is simple but I don't know how to implement it. I have a form where employees select their names from a drop down before they add their hours in perspective text boxes. I want their mug shot picture to show up on the form as they select their names. Can someone please by providing...