works

  1. A

    Target.Column + 8?

    Hello I have an Excel spreadsheet that will be used for data entry without userforms (to allow for Mac users). I intend on password protecting it to make data entry easier. It works as I hope however I found the code on the internet and whilst it works I don't quite understand one line of code...
  2. D

    Cells property question Run-time error 1004

    Hi Trying to understand Cells property better. When I use Cells property below for Sheet1 it works, but when I try to then use Cells property against SHEET2 I get Runtime error 1004. It seems that Cells property is tied to Sheet1 somehow. Can someone explain what is happening under the...
  3. J

    How to split units from numbers stored in a cell that is custom formatted

    Hi All! I am new to this forum. Need help. I need to separate units from quantities. i am not being able to do it because cells that are custom formatted and no text function works on these. When converted to text format, the units automatically disappears! Can you please help me out on this.
  4. Y

    Compare two worksheet with new and missing rows and highlight cells of differences

    Need to compare last years old worksheet "sheet1" to current worksheet "sheet2" They have the same 12 columns, first column A is unique Request Job Number Both worksheets are similar but not the exactly the same size about 200 rows Completed job requests on old worksheet are removed from current...
  5. M

    Excel 2010 xlsm file errors in Excel 2007

    Is there a way of ensuring a Excel 2010 Macro Enabled file works fine in Excel 2007 ?
  6. F

    Step through a Macro

    I just bought the latest version of Excel and I use to be able to step through my macros with F8. It no longer works. Also My control buttons don't work. Has it changed?
  7. bfreescott

    Offset

    anyone have an experience with offset returning a wrong data type error when increasing the height above 1? =OFFSET(A1,0,0,1,1) works just fine. =OFFSET(A1,0,0,2,1) produces wrong data type. Starting with a different reference doesn't seem to make a difference.
  8. G

    macro stops and ends program and restarts Excel

    I have a macro which works perfectly for one search and will display the information correctly. This macro is then cycled by another macro to view other matches for the same sort information which works correctly. Problem is after (about 20 or more) cycles, the total program goes belly up and...
  9. NewOrderFac33

    VBA Date Filtering Query

    Good afternoon, When I use the following code to filter an Excel database to all rows where the date in the first field is less than or equal to the value in the named range "DeleteOldest" DODCriteriaString = "<=" & Format(Sheets("Database").Range("DeleteOldest").value, "yyyy/mm/dd")...
  10. M

    Conflicting codes?

    I have code that puts data into columns depending on weather or not the check box is checked. I also have code that checks the value of the cell and re-checks the box if >0 I Can't seem to get both codes to work, whichever on I have first works but the other doesn't. If I switch the order then...
  11. A

    VLOOKUP Not Showing Result ?

    It's a pretty simple function - just look down the column range and display the cell that is not blank... =VLOOKUP("?*",A2:A12,1,0) It works when there is text in the cell - but gives an error when the cell shows a number? What is the fix? Thanks for your help!
  12. I

    Printing to another printer than the default printer

    So I have this excelfile where I print labels to a Zebra printer. Normally I don't have the Zebra printer as default printer because I also print other stuff on a normal printer. Application.ActivePrinter = "Printer2 på Ne2:" I tried this and it works, but our server keeps changing the Ne...
  13. D

    xlveryhidden macro runtime error 438 object doesn't support property or method

    hi, if anyone could explain why this is happening i would be very grateful I have a hidden sheet 'Exp' that is password protected, and automatically hides (veryhidden) when the user navigates away from it. This all works fine. The incorrect password message works too. But I am getting this...
  14. C

    Indirect Function to reference another page

    I'm having issues with the last part of my formula. I have two sheets, a results page (where the formula is written) and the Database page where all results will be stored. When I write this formula out on the database page, it works exactly how I want it to, just need it to work on my results...
  15. J

    SumIf works but SumIFs does not?

    This formula works fine: =SUMIF(I30:I42,">="&I2,G30:G42) This formula gives me a "#Value!" error: =SUMIFS(G30:G42,I30:I43,">="&I2) I have under criteria for the SUMIFs which is why I can use SUMIF but it was erroring out so trying to figure out why.
  16. S

    Issues referencing other sheets name manager

    hello all this is the formula i have which works great which references a worksheet but i also need it to perform the same commands and keys but from another worksheet IFERROR(INDEX(T_LEAVE56[TYPE OF UNIFORMS],SUMPRODUCT(--(T_LEAVE56[EMPLOYEE NAME]=$B9),--(T_LEAVE56[START...
  17. G

    #SPILL! error with sumifs

    I am using office 365 and when I do a sumifs formula and I reference a entire column for my criteria I get either a zero or a #SPILL ! error. It only works when I reference the specific cell. This used to work in older excel versions. Can I no longer reference a full column for my Criteria...
  18. D

    =sum not working

    I have a sheet with a formula to grab numbers from a string from this formula =iferror(mid(A6,find(320,a6)+4,6),"") in the H column. i have the formula =sum(H:H) in the N column and always get 0 for a response instead of the total. I have this same formula on other sheets and...
  19. W

    Express formula in VBA

    Hi, I am trying to change some formula in my file with VBA calculations, but as the formula is bit complex, have troubles expressing it in VBA. Result of the formula should be count of all projects started this month from 2 sheets different than the one it is present in. Formula in sheet works...
  20. O

    Excel formula is turning into a link when saved in some computers

    Hello all, I need help with this problem. Spreadsheet works fine in my computer and another colleague's computer. Our computers are not networked in any way. However, it is also opened in a computer using Chinese regional setting and language is when the formula became broken. For example...

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