cool

Hello, I have a huge workbook with several tabs. I would like to be able to select the tab called "Main" by simply double-clicking anywhere in the spreadsheet. I tried with the code below (ThisWorkbook module) but it does not work :cool: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As...

Hi Guys, Im wondering if I could lookup partial match based on below case; let say I have value in column A row #1 in sheet A: <tbody> "Rexona Men Deodorant Roll On Ice Cool 50ml" and in the other sheet (Sheet B), I have value: <tbody> "Rexona Ice Cool Roll On 50ml" What I need is to...

I want to conditionally format (highlight) a certain cell IF any number in a particular cell in that range is above 3. My rows go left to right. So in #1 Row, I want the #1 to be Highlighted because the 3.5 is above 3. The #5 would be highlighted as well cause it has two such numbers 3.2 &...

I am stumped a bit on this one. I want to count the number of cells that have a ZERO (0) in them. I do NOT want to count any blank cells, just the cells that contain a 0 in them within a range. What is the formula for this? Thanks in advance for any help on this! Regards, U.S. :cool:

Hi Once, I saw a site which has .xlsx files which demonstrate cool applications like Analog clock, games, digital clock, thermostat etc. I tried to google but no success. Have you seen such website or do you know one. Thank you so much.

So I need help writing a code that will effectively move this data, ignoring column C and F in the source and put in the new sheet, in a different location. But it just puts it in the next available row, so in the example, as I add more Cool Guys, it wont overwrite my current list of Cool Guys...

Hello, My name is James Pace and I am a MBA student at Brigham Young University. I am doing a marketing project on Excel and would like to interview people, through video chat, to obtain Excel consumer insights from the Excel love group. If you love Excel and would be willing to share your...