Search:

Type: Posts; User: =ODIN=; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: VBA to find rows with specific text and count the zeros

    Does it need to be a macro?

    You could use an array formula to do this in a helper column.


    If your data has sub-total in column d, and you wanted to counted the zeros in columns e-h you...
  2. Re: Run many large update queries in the right order one at a time possible?

    You absolutely can do that.

    fast foward to 3:40 in the below video
    https://www.youtube.com/watch?v=WPBYxh4WuXE
  3. Re: VBA to copy data from multiple workbooks into one sheet if condition met

    I'm not sure how comfortable you are with coding, but my advice would be to code it this way (pseudo code below)



    dim pasteRow as long 'will keep track of next unused row on main sheet for...
  4. Re: extracting data from Multiple tabs into a table by matching text in column

    One way you could do it is to use a free tool called "generic Consolidator" to consolidated the data from all 50 tabs to one tab. Then apply an auto-filter to the consolidated data and filter on...
  5. Replies
    11
    Views
    338

    Re: Rearranging Data in Excel

    It looks like what you are trying to do is called unpivot. If you have excel 2016+ you can use the built in power query to do this I think -- I've never done it, but you should be able to google it....
  6. Re: If Chip Pearson's website ever helped you, please jot a note...

    I never new Chip, but he and his work were a good influence on my life. I'm sorry for my late condolences -- I've managed to recently visit his site before ever even reading this sad news.
    ...
  7. Replies
    1
    Views
    237

    Re: Run Access Macro from Excel

    In order to rule out whether it is a library reference issue, try late binding the access app.

    Just change your one line of code:

    Dim AccDB As Access.Application

    to


    Dim AccDB As object
  8. Replies
    5
    Views
    378

    Re: Speed Up Formula for +3000 rows

    Have you worked with arrays in VBA yet?

    If not, that is what you should start researching.

    Since excel 2007 and beyond, cycling through cells in a range has been extremely slow, so the best...
  9. Thread: userform help

    by =ODIN=
    Replies
    2
    Views
    215

    Re: userform help

    I feel like i'm missing something here. Is there anything stopping you from using vlookup in your code to get the email associated with comboBox1's value?
  10. Re: combining texts (many many cells) in a smart way. Guidance needed!

    If you have excel 2016 the textjoin function might do this -- I'm not certain because I don't have it.

    I use the Nutilities addin for this myself. If you have excel 2007 and up, you can use it...
  11. Re: Pause or stop VBA for a manual edit to the sheet

    It looks like your code was deleting one row at a time. Have you tried applying an autofilter and then deleting all the rows at once?
  12. Re: Pause or stop VBA for a manual edit to the sheet

    While you guys are technically correct in that you can’t stop and start a sub while you edit a sheet, you can use a mode less userform with a single button and sub that will simulate the effect. The...
  13. Re: Pause or stop VBA for a manual edit to the sheet

    What you are describing can’t be done with a standard excel msgbox. You could manage it with a modeless userform though.
  14. Replies
    2
    Views
    169

    Re: Copy and Move files and folders

    I don’t have my computer in front of me to test this, but this might work.

    Try fixing the from path line to this:


    FromPath = “A:\*”
  15. Re: Disagreement between VBA Round & FormatNumber functions

    Just tossing this out there on the off chance that it’s your culprit. Are you using range.value in any of your calc? If so, try changing it to range.value2 and see if it helps.
  16. Replies
    2
    Views
    250

    Re: Waiting command button

    I have some convoluted ideas on how to do this with an extra visible:=false button on the form, a global variable, and a helper function... but it seems like way more effort than it's worth.

    It...
  17. Re: How to convert Pivot table structure (values) into actual Pivot, or data tab ready for pivot

    I use the Nutilities Addin for this. It's free and available here: iwishexcel.com


    Once installed, if you hit CTRL+SHIFT+ALT+ENTER in excel, a popup will have a list of tabs showing directions...
  18. Re: Loop over Multiple Arrays Causing Invalid Qualifier Error

    Also, maybe try removing the .value from these 2 lines:


    myEndRecordArray(i).Value = VLookupResult
    myPrintCountArray(i).Value = LookupResult

    to


    myEndRecordArray(i) = VLookupResult
  19. Re: Loop over Multiple Arrays Causing Invalid Qualifier Error

    What are the values of "i" and "VlookupResult" right before the error is thrown?
  20. Replies
    1
    Views
    126

    Re: Duplicate Fields in a Pivot Table

    Sorry, your question is too generic for a great answer. However, you Bucket2 sounds like a pivotfield that was manually grouped on your pivot once it was already created.

    Please can you either...
  21. Replies
    4
    Views
    190

    Re: VBA Pivot Table Issue

    Sorry, your code is harder to read than one would think, despite all your comments.

    I'm thinking that there are probably 2 possible problems here --

    1. Your code is not passing a correct...
  22. Replies
    4
    Views
    393

    Re: File size vs. battery life

    In Mythbusters style, I would say that is plausible. Anything that causes your computer to 'think' more makes it use more power. This is especially true in computers that have older spinning...
  23. Replies
    3
    Views
    583

    Re: Essbase / Smartview VBA - Connect Code?

    Sorry, no idea. I only ever managed to connect through vba if I had already manually setup that private connection first.
  24. Re: Copying a formula from one Excel worbook to another Excel workbook

    Sorry, I'm not certain I entirely understand the complexity of what you are trying to do, but I think this might handle the situation you have listed in your last post.

    It assumes that...
  25. Replies
    3
    Views
    583

    Re: Essbase / Smartview VBA - Connect Code?

    Below is some code I successfully used to connect to essbase cubes in the past.

    Make sure to have all the declaration pasted in at the top of your code module before any subs() -- I have more...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4