Search:

Type: Posts; User: parkerbelt; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    8
    Views
    167

    Re: vba correct syntax needed

    Could be. I have 365 ProPlus version
  2. Replies
    8
    Views
    167

    Re: vba correct syntax needed

    I got the same error using your new code. Thanks though!!
  3. Replies
    8
    Views
    167

    Re: vba correct syntax needed

    I ended up doing this and it worked:


    Sheets("Test Stores - Chart Data").Select
    lastTableCol = Cells(3, Columns.Count).End(xlToLeft).Column

    Range("Table1[[#Headers],[Week...
  4. Replies
    8
    Views
    167

    Re: vba correct syntax needed

    That code brought back "Run-time error '1004':

    Delete method of Range class failed
  5. Replies
    8
    Views
    167

    vba correct syntax needed

    I have a program and I have some code that deletes columns from a table starting at week 2 and going to the right to the last column. I recorded the syntax from the Excel VBA recorder and it has...
  6. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    I tried the code the way that you sent it and it didn't work with the copy to location part in it, so I recorded the Advanced Sort steps and used your lastrow designations and made it work. It is not...
  7. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    This ended up working. Something must have been wrong with the CopyToRange that you sent.



    Sheets("Temp Dump").Select Range("A1").Select Range(Selection, Selection.End(xlDown)).Select...
  8. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    No
  9. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    I tried your code and it copied 521 rows of data from the "Temp Dump" tab and pasted it into the "Test Stores Data" tab, but it didn't filter out any of the stores that weren't in the "500 Test...
  10. Re: Macros disabled - Greyed out in Trust Settings - Can't turn it back on

    I tried that and it didn't work. Turned out that I had to just start over with a new excel file and just re-create the file and module. Thanks for trying though!!
  11. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    I can't try it until I figure out how to enable macros - the option is greyed out and won't let me change it. Not sure what's wrong yet.
  12. Re: Macros disabled - Greyed out in Trust Settings - Can't turn it back on

    The file is saved as an .xlsm file
    I had saved it before running the code, so I don't think I needed to retrieve it. I opened it right up from windows explorer.
    Is there a different way to retrieve...
  13. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    Only 9857
  14. Macros disabled - Greyed out in Trust Settings - Can't turn it back on

    I was writing a program and got hung in a loop, so I ended Excel through Task Manager and now I'm getting the message "Because of your security setting, macros have been disabled." I tried going into...
  15. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    I was running my program, the code that I had written and got hung in a loop, so I ended excel using task manager and now Excel is telling me "Because of your security settings, macros have been...
  16. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    Below is the information that you requested. If the store number is in the 500 Test Stores list, I want to copy all of the rows for that store from the Temp Dump tab and put the data in the Test...
  17. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    Your code worked to find a match and to put one line of data from the match into the Test Stores Data tab, but it didn't put the other rows of data from the other item numbers in there.

    It also...
  18. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    Ah. I had it called "Temp Dump" not "Test Dump"
  19. Replies
    22
    Views
    222

    Re: vba indexed search syntax

    I'm getting Run-Time error '9':
    Subscript out of range and this line is where it stopped:
    Set sh2 = Sheets("Test Dump")


    Not sure why
  20. Replies
    22
    Views
    222

    vba indexed search syntax

    I have an Excel workbook that has a sheet that has a list of 500 stores numbered Store number 1, store number 7 store number 11, etc.. - these are my test stores. The store number is in column A. I'm...
  21. Re: Abbreviated formatting of numbers in Excel - Negative numbers not right - custom formatting

    Thanks for your help!!
  22. Re: Abbreviated formatting of numbers in Excel - Negative numbers not right - custom formatting

    I figured it out. Had to change the number format to custom in the chart
  23. Re: Abbreviated formatting of numbers in Excel - Negative numbers not right - custom formatting

    That worked for formatting the number, but the chart that I have built off of that number changed to the un-abbreviated number. Is there a way to fix that?
  24. Re: Abbreviated formatting of numbers in Excel - Negative numbers not right - custom formatting

    Thanks guys! You wouldn't happen to know the conditional formatting formula that would make that happen or some other way to accomplish what I'm trying to do, would you?
  25. Abbreviated formatting of numbers in Excel - Negative numbers not right - custom formatting

    So, I'm using custom formatting to show -$1,200,000 as -$1.2M, but Excel is showing it as -$1200K.

    Here's the custom formatting that I'm using:
    [<999950]$0,"K";[<999950000]$0.0,,"M";$0.0,,,"B"
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4