cell2

  1. E

    Cell value combination question

    Hello! I'm working on a code and have come upon something that I hope has an easy way to do. In it, there are 3 cells in the workbook. Each cell can only have 1 of 3 possible string values in it. For this example say A, B or C. Depending on the combination of letter, they receive a different...
  2. C

    VBA - Application-defined or object-defined error

    I know I must be missing something silly here. I keep getting the error message, "Run-time error '1004': Application-defined or object-defined error" on the bolded line below. Can't seem to figure out what I'm doing wrong. Sub EEE_Reformat() Dim wb1 As Workbook Dim cell1 As Range, rng1...
  3. M

    Custom Formatting of Numbers in a cel

    Id like to format a cell that is the result of two other cells. There should always be 5 digits to the left of the / and 2 digits to the right of the / . Cell1 Cell2 Cell3 (Result) 1234 1 01234/01 34567 2 34567/02 Thank you in advance Al
  4. M

    VBA to Loop through a Column based on a value

    I'm trying to write a sub that loops through the values in the C column of the "Changes" worksheet and looks for the corresponding value in the "4Q2017" worksheet. If there is a match, the cell two columns away in the "Changes" worksheet should take the value 72 columns away from the matched...
  5. O

    MATCH returns #N/A but EXACT returns true

    Hi, I have the following scenario: Cell1=6.99 Cell2=6.99 Lookup range contains value 6.99 Cell1 and Cell2 both have same format and contain the value of another lookup formula. The MATCH function returns #N/A for Cell1, but not for Cell2. When I check equality with =Cell1=Cell2 and...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top