Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Replace blanks in "big" sheet / fastest way

    Are there any formulas? If not I would suggest assigning the value2 property of the usedrange to an array, iterating round the array, then putting in back again once all your replacements are done. ...
  2. Replies
    6
    Views
    271

    Re: Do until...time/power consuming

    Pleas note missing:

    Application.ScreenUpdating = True

    At end of procedure...
  3. Replies
    6
    Views
    271

    Re: Do until...time/power consuming

    You can also check to make sure you need to toggle the visible status:



    Private Sub Worksheet_Activate()
    Dim x As Integer

    Application.ScreenUpdating = False
    x = 2
    Do Until x = 190
  4. Replies
    6
    Views
    271

    Re: Do until...time/power consuming

    It will take a while - but would suggest as a minimum you make sure you turn off screen updating (and perhaps auto calculation):



    Application.ScreenUpdating = False

    blah
    ...
  5. Replies
    1
    Views
    260

    UDF called from Wizard

    Hi Guys

    I have a series of VBA UDF's that are reasonably long running - and I dont want them to perform their normal calcs when called from the Function Wizard dialog.

    My basic question is -...
  6. Re: Name worksheets (tabs) according to value present in cell

    As a minimal attemp the below will work - consider adding error trapping for illegal names etc...



    Private Sub CommandButton1_Click()
    Dim oWks As Worksheet

    For Each oWks In...
  7. Replies
    20
    Views
    1,740

    Coolio, however I think I also have Nories...

    Coolio, however I think I also have Nories concern that there is a more fundemental issue if you are having to input 500 of these by hand. Sounds like a big numbr of inputs to have without a pattern...
  8. Thread: SQL query???

    by macleanb
    Replies
    1
    Views
    473

    Suggest a google for "ADO VBA EXCEL" will give...

    Suggest a google for "ADO VBA EXCEL" will give you more than enough reading material - e.g.

    http://www.exceltip.com/st/Import_data_from_a_text_file_(ADO)_using_VBA_in_Microsoft_Excel/430.html
  9. Replies
    20
    Views
    1,740

    Dim lookuprange As Range set lookuprange =...

    Dim lookuprange As Range
    set lookuprange = range("Sheet3!A:B")
  10. Replies
    1
    Views
    603

    I think your issue is using the...

    I think your issue is using the "selection.rows.count" in a function - doesnt sound like a good idea to me (e.g. its going to be very indeterminant) Find another way!
  11. Seems to suggest the the required value is not...

    Seems to suggest the the required value is not found - the value sought is definately to the right of column CD?
  12. I was assuming you were running this code from...

    I was assuming you were running this code from within the Worksheet code - the "Me" refers to the workshet itself (where the code is run from) THe problem of the code (sorry I didnt check it from...
  13. Replies
    1
    Views
    622

    Thats a very long post without using the code...

    Thats a very long post without using the code tags! The answer is to use your computers "Scheduled Tasks" feature to run and Excel command line. There are various way you could construct this...
  14. Woops - left in the "With" by accident - please...

    Woops - left in the "With" by accident - please remove....
  15. Something like: Me.ChartObjects("Chart...

    Something like:

    Me.ChartObjects("Chart 9").Axes(xlValue).MaximumScale = Me.Range("W26").Value
    End With
  16. Oooh - echo post! Sorry

    Oooh - echo post! Sorry
  17. You can actually embed char(10) as part of your...

    You can actually embed char(10) as part of your formula - though I think this will only work if you have wrap text on (that might not be acceptable - sorry)
  18. Could the code its running be responsible?

    Could the code its running be responsible?
  19. Replies
    7
    Views
    941

    Hi So currently yoyu have one table that shows...

    Hi

    So currently yoyu have one table that shows pounds going up in steps and the equivalent in the other currency (lets assume AED). If you are starting of with a mental question "how many AED is...
  20. Replies
    2
    Views
    1,864

    Great - 2 lines for a work around suits me fine -...

    Great - 2 lines for a work around suits me fine - but am I misunerstanding the documnentation - it soes seem to sugeest saves should be worksheet specific.

    thanks
  21. Replies
    2
    Views
    1,864

    Worksheet.SaveAs

    Hi

    (First let me apologise for this post - I am sure the answer is available, but my searches returnn soooo many threads, none of which are relevant, I have gone for the easy option and ask...
  22. Replies
    7
    Views
    941

    Hi Other thoughts: 1. Have some way to...

    Hi

    Other thoughts:

    1. Have some way to control which currency is the "driver currency" or have two tables to show both CCYA/CCYB and CCYB/CCYA.


    2. If you do the above you probably need...
  23. The other alternative is to create or modify...

    The other alternative is to create or modify these controls at runtime using VBE automation.
  24. Cool (though a bit modern for me :-) ) Its like a...

    Cool (though a bit modern for me :-) ) Its like a "Tardis PC"
  25. Have you considered using a hidden default button...

    Have you considered using a hidden default button to trap this event?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4