macro error

  1. L

    Macro error

    My macros are enabled and working fine, but everytime I open the formulas or data tab for the first time I get this message "because of your security settings macros have been disabled. to run macros, you need to reopen this workbook, and then choose to enable macros, for more information about...
  2. B

    Macro code is not working in Excel 2013 (I think due to appliation.filesearch errors) Help most appreciated

    My old boss has retired and I had a document cotrol sheet that opened files (any format including PDF's) from folders with the same name as the tab. since i have now been forced to use excel 2013 it does not work. Please can someone help me!!! The code is below: (I think it is somthing to do...
  3. L

    Macro to convert HTML within a cell to a rich text formatted cell

    I am trying to use the below macro to copy HTML into IE10 and paste back into excel in a rich text format The error message is 'Run-time error '438' Object doesn't support this property or method. When I debug it appears to be something wrong with the copy line? Sub Sample() Dim Ie As...
  4. MrManBoy

    How to Display Error Message if there is a macro error?

    Hi Team, I have the below code to delete these particular workbooks for example, however, in the case the user runs the below macro again & the file(s) have been deleted already, I would like to learn how one could stop the macro and then have a message displaying something like "Files have...
  5. G

    error 1004

    I keep getting this error when I run my macro.... "Cannot change part of a merged cell" I've checked my sheets and I have no merged cells..... is this a bogus error or does it really mean something else?
  6. S

    What is the difference between variables and object variables?

    Hi all, i have some difficulty in understanding the purpose of both types of variables in excel macro. Furthermore, i have a problem in my codes right now, Dim TotalRow As Integer Set TotalRow = ActiveSheet.Rows.Count ActiveCell.Copy For i = 1 To TotalRow...
  7. D

    Data and chart on separate sheets

    A question, if I may: my data, and a chart of the data, is in sheet 7 of a workbook. I have a macro that redraws the chart as the data changes. (I set some cells to generate random numbers on 'calculate' command in the macro) . The macro references sheet 7 and the data. For viewing purposes...
  8. O

    Stopping error from showing VBA

    Hi Excelperts I have a little macro to clear the autofilter on my page. But if the filter is ALREADY clear, it gives me an error. I have to get it to just do nothing if its already clear to stop this error from popping up (as its going to be distributed to others) This is my code: Sub...
  9. S

    Macro error at cell: ScDataWorksheet!

    Hi all, :) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> When my users open or close files I create for them they get the following Macro Error Box. (Some users do not get the Error Box)<o:p></o:p> <o:p></o:p> Macro error at cell: <o:p></o:p>...

Some videos you may like

This Week's Hot Topics