.address

  1. L

    Need Help With the VBA .Formula Property With Variable

    Guys/Gals, I am trying to have the below code place a formula in Cells(lRow, 3) that contains variables. However, every time i try this it shows a #Name ? error. I have searched on this forum for additional help, but i can't get their solutions to work in my code. Can someone please show me the...
  2. S

    Leading Spaces - something odd ?

    Hi, I have some code from this site that removes leading spaces from most cells in my data, but not all. What sort of thing could cause these 'unknown' spaces and how do i deal with them please ? Here's the code: Sub RemoveLeadingTrailingSpaces() ' hiker95, 02/26/2016, ME9242394 With...
  3. J

    VBA problem with conditional formating using .address to point to cell with conditional value

    Hi all Can someone help me with a piece of conditional format via VBA. It is doing my head in. Excel somehow changes the input value from my input box - it is simply different to what I select when prompted. I want to set a conditional format. First I prompt user to select which cell to...
  4. B

    .Formula with cells from different sheets

    Hello Everyone and once again thank you for all your help. I am trying to use activecell.formula however a few of the cells I need referenced are from different sheets then the one I am currently in and when I used cell.address it puts the address in but for the sheet I am working in. Here is...

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