1. J

    Password question, but not a "how to crack" question.

    Hi folks, I wonder if anyone knows a way to determine if a worksheet is protected WITH a password vs. protected without a password. I know how to check for protection in general...but not how to figure out if there's a password attached to that protection. Any insight/direction is greatly...
  2. H

    Selection.Find not finding number with scientific number

    Hi everyone, I declare a variable as variant. The input for the variable are mostly strings and some scientific numbers. The Selection.Find keeps giving errors whenever it tries to find a scientific number. I formatted the data in the search row as "general". Below you can find part of the...
  3. M

    cell format changes from General to Date format

    Cell fomat gets changed automatically from General to Date.
  4. F

    Flagging duplicate emails

    I was hoping for assistance with flagging a sheet of duplicate emails. Below are considerations and matching criteria: There can be 2 rows of the same email, or 3 rows, or 4 rows, etc. The first criteria that should determine which row gets flagged is the higher the General Number is, that...
  5. auto.pilot

    Seeking assistance with run time error 432

    I have the following code, which simply opens workbooks that are all in the same folder (this is the source). the code then copies a range on the General worksheet within each of the workbooks. The range is then pasted to the destination workbook (the one with this code). All of the workbooks...
  6. M

    Conditional Formating not working with value returned with IF statement

    I have a formula that returns a number 1,3,4 with the following =IF(E3=D3,"",(IF(E3="R","3",IF(F3="R","4","1")))) I want to highlight values of 3 and 4 but I cant seem to get the conditional formatting to work. I have played with the format of the cells making them numbers, texts, general, etc...
  7. R

    General location and Restrict location

    Hello, I've searched several threads but I couldn´t find one that could help. I'm trying to find a formula and a VBA function that is able to return the location of a string in a sheet (A) and also within a restricted area (B). This is what I want for each Output (A and B) with 16.03 for...
  8. J

    .Replace not working

    Guys, i have a simple code: With Rows("3") .Replace What:=",", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False End With The goal is to change the regional settings. I want to get rid of ","...
  9. F

    Format number

    In Excel, I want to format a number as "General", together with commas to separate multiples of 1000. The current General format excludes the commas. For example: INPUT: 1245.32 SCREEN OUTPUT: 1,245.32
  10. W


    I have a column of approx 350 entries. Generally the data is as follows <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}td {padding:0px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none...
  11. D

    Original Fractions in Spreadsheet Don't Convert to Fractions

    Hi guys, I'm having this weird issue in my spreadsheet. I have columns populated with fractions but in excel they are not yet selected as fractions (They are "general"). When I select them and change the data type to fraction, it says its a fraction but there is no change. When I individually...
  12. H

    Array numberformat: need to change

    Hi I'm learning about splitting and joining. I have a cell, which is a dose response of concentrations in scientific notation. I have got to the step where my array is filled with each concentration. I now need to change the format from 1.0E-6 to 0.000001 I've attempted: WrdArray(i) =...
  13. V

    Sum value from dropdown list menu

    Hi There! I need some help to sum up the value for drop-down list. Each item in the drop-down list should have a value tagged with it. This is the scenario: <colgroup><col><col><col><col><col><col></colgroup><tbody> Subject Name Type Status Appointment ID Time...
  14. B

    Formula help

    Hi I have a data column that shows a series of level 1 and level 2 tags. the data presents as L1 space and then the name of the level 1 tag then a comma space then L2 space and the name of the level 2 tag. See examples below I urgently need a formula that returns the L1 tag name and a second...
  15. H

    why (0001,0001) becomes -10001

    Hi Experts, I tried to enter (0001,0001) into an excel cell. The excel displayed the value as -10001. The cell needs to be "(0001,0001)". Any idea? Thanks a lot!
  16. D

    General to date

    I have 3 columns Column A has a general number ie 1 for January Column B has a general number ie 10 for tenth day of January Column C has a general number ie 2017 How do I get column d or e to combine 1/10/2017 to represent January 10, 2017
  17. M

    Calculation based on conditions

    Excel 2007. Cell A1 : contains income in numerical, for example 1500000 Cell B1 : contains category in text. The text will be either GENERAL or SRCTZN B1 will display only GENERAL or SRCTZN. Cell C1: contains formula to calculate Tax for GENERAL category. Cell D1...
  18. M

    going to a new pay system

    we are going to a new pay system. Instead of just a standard hourly wage, employees will be able to make a higher wage based on the production of the plant they work at. I am looking for help with a formula that will assign the new wage per hour based on the level of the employee and the amount...
  19. jim may

    Referencing Text Cell within Formula

    I'm vaguely familiar with the INDIRECT() formula, but not enough to solve my problem. In my Worksheet Named MAIN I currently have the formula (WHICH WORKS!!): =SUM('Aug 2017'!K25:K28) I was to modify the above so that I can reference in the 'Aug 2017' portion using another reference. In my...
  20. C

    VBA Replace format but not value

    Hi gurus, I am trying to put together VBA to search for a specific cell format and then change that cell format. The cell formats I am wanting to replace are the variety between "< 1" and "< 0.00001" (formatted general); I want to replace them with proper number formatting ("< 0", etc.)...

Some videos you may like

This Week's Hot Topics