Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: VBA Inserting columns and keeping formulas in Table Ranges

    Just a last info to finish off this Thread..: This helped me get the Inserting discussed in this thread a bit clearer.......
  2. Re: VBA Inserting columns and keeping formulas in Table Ranges

    Brilliant ! :)
    And thanks again for sharing !!!
    Have a good Sunday!
    Alan

    ( I might just "turn the error handler off once you have finished using it, as good practice, but that is a very minor...
  3. Re: VBA Inserting columns and keeping formulas in Table Ranges

    Hi


    Wow, great,
    and thanks for sharing the codes... :)

    I am not too good on UserForms. I think you have to create them some how and Name them .. etc... :confused:
    And named ranges have to...
  4. Re: VBA Inserting columns and keeping formulas in Table Ranges

    Hi Prisch,


    Yous welcome. Thanks for the feedback :)
    _............

    -.. as i mentioned the final code can be simplified greatly.....
    _...................................
  5. Re: VBA Inserting columns and keeping formulas in Table Ranges

    The main codes now, and some brief explanations

    Rem 1)
    Gets all the important info of where things are, including Top left of the two tables

    Rem 2)
    Determines where the row or column will...
  6. Re: VBA Inserting columns and keeping formulas in Table Ranges

    Ok, here we go :)

    This sort of thing is almost certainly done best with “VBA Tables” and Named Ranges etc.
    The VBA Guide To ListObject Excel Tables
    ( “VBA ListObject Excel Tables” stuff )

    ...
  7. Re: VBA Inserting columns and keeping formulas in Table Ranges

    I should have noticed it myself, with hindsight it is obvious , like most things. But it is all good llearning :)
    I want to tidy up and do some explanations on the codes for later referrence, then...
  8. Re: VBA Inserting columns and keeping formulas in Table Ranges

    Hi Prisch,

    I think i have some final codes for you and will drop them off for Today or early tomorrow..

    But in the mean time I think we may have overlooked something....:rofl: :eeek:

    ...
  9. Re: VBA Inserting columns and keeping formulas in Table Ranges

    OK ,
    got all that last info, no problem there,.. i think..
    _. just one thing..


    Do you always add a column in both tables, or should that also just be done on the selected table, sales or...
  10. VBA Inserting columns and keeping formulas in Table Ranges

    Hi,
    OK., I will give it a go
    Some questions,

    _1) Does the data ( the Total Tables Area ) always start at B4? ( In other words will Top Left "Salesperson" Table always be at B4?

    _2) Is...
  11. Replies
    4
    Views
    312

    Re: FREE instructional videos

    Thanks, :)

    One quick thing, - if you try to do what i did and download and make yourself a long continuous Play list, then be very careful what download and converting Software you use. Most of...
  12. Re: Help - VBA code inserting columns and keeping formulas

    Hi Prisch,
    Having sample data to work with like you supplied makes it a lot easier to “see” what is going on, thanks, :)

    If we can see screen shots in the Thread showing the “Before” and...
  13. Thread: Code tags

    by DocAElstein
    Replies
    16
    Views
    1,214

    Re: Encouraging New members to read up on FAQ, Forum Posting Guidelines, and using Forum Tools.

    Thanks Mole,
    _...thought it was probably a "no go-er", just thought I would check
    Alan
  14. Replies
    4
    Views
    312

    Re: FREE instructional videos

    Hi sandler,:)
    Try these play list, a couple you may have
    http://www.mrexcel.com/forum/excel-questions/910633-learning-visual-basic-applications.html#post4379209
    I find if you can download them and...
  15. Thread: Code tags

    by DocAElstein
    Replies
    16
    Views
    1,214

    Encouraging New members to read up on FAQ, Forum Posting Guidelines, and using Forum Tools.

    I bet this is a Dopey question, :nya:, so apologies in advance for it..

    Is there any way to supply an OP ( maybe at registration ) with a File that somehow has, or sets up, initiates, or whatever,...
  16. Rick version

    '
    ' Rick http://www.mrexcel.com/forum/excel-questions/936650-command-like-mid-takes-characters-end-string-instead-front.html#post4499624
    Public Function LeftRight(ByVal str As String, ByVal...
  17. Replies
    3
    Views
    405

    Re: attach an excel file

    Hi NIPUL JARIWALA

    Welcome to the Board :)



    You cannot, if it is important a Mod may help you - click the report button below on your post and ask.
    ...
  18. Jonmo1 version .....

    ' Jonmo1 http://www.mrexcel.com/forum/excel-questions/936650-command-like-mid-takes-characters-end-string-instead-front.html#post4499565
    Public Function MidFromRight(ByVal str As String,...
  19. Function like MID that takes characters from the end of a string instead of the front?

    Hi dan, :)

    I do not think there is a Function to do that.

    So make one. ( macro stuff!! )

    Like this:.....


    Sub MidRight() ' ...
  20. Testing

    You can Test and Experiment here
    Test Here
    :)
  21. Methods to Modify Code to use Last Row and Last Column rather than Hard Coding

    Hi ShumsFaruk


    Thank you!
    Alan
    :)
    _.........
  22. Thread: Code tags

    by DocAElstein
    Replies
    16
    Views
    1,214

    Re: Encouraging New members to read up on FAQ, Forum Posting Guidelines, and using Forum Tools.

    Hi Mole, :)


    ...yeah..
    It increases the number of members I think... So actually means i think that some of my numbers are underestimates in terms of % of "real members"... but all depending...
  23. Thread: Code tags

    by DocAElstein
    Replies
    16
    Views
    1,214

    Encouraging New members to read up on FAQ, Forum Posting Guidelines, and using Forum Tools.

    Hi Micheal :)


    Managing and Enforcing Rules and posting suggestions and encouraging them in a free Forum is a difficult thing I guess. :sad:
    I did a similar Thread some time ago...
  24. Re: Determining The Last Column In Current VBA

    Just to complete my demo codes using ShumsFaruk solution way....


    _...................................

    Following demo codes, for example working on this:

    Using Excel 2007
    Row\Col
    A
  25. Re: Determining The Last Column In Current VBA

    Hi ShumsFaruk



    You are welcome, thanks for the feedback.. :)
    And thanks for sharing your soolution! :)
    _.....................................................
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4