Posts by xlite

    Re: Run Macro For Specific Workbook In Background


    hi tgit,


    welcome to Ozgrid.com.
    try specifying the target file and the sheetname before pasting the values


    hope this helps


    [QUOTE=tgit]


    QUOTE]

    Re: Forecast Linear Trend Between Min And Max Value


    hi purp,


    welcome to Ozgrid.com.


    you can try using multiple [if]*[/if]:
    =IF($L$7>$F$11,100,IF($L$7>=$F$10,FORECAST($L$7,$G$10:$G$11,$F$10:$F$11),"No bonus earned"))


    hope this helps

    Re: Autosave Spreadsheet At Certain Time


    hi HelC,


    welcome to Ozgrid.com.


    i assume the spreadsheet is open?
    if so what is being written/edited that you need it to be saved at a certain time?


    can't you use autosave instead?

    Re: Get The Nth Character From String


    Quote from Wigi

    No, but almost


    Code
    Range("A2").Value = Mid(Range("A1"),3,1)


    Wigi



    he wants value only, but i gave him formula. :p


    definitely time to sleeeeep :sleep:

    Re: Copying Sheets With Named Cells


    hi lingyai,


    try this code:


    hope this helps

    Re: Select rows with data


    Quote from vandanavai

    I want to write VB code to select only those rows which have data.


    hi,


    try this:

    Code
    Sub SelectData()
    Dim myRng As Range
    
    
    Set myRng = Sheets("Data").Range("A1", Range("D65536").End(xlUp))
    myRng.Select
    End Sub

    Re: Compare Sheets For Changes


    hi Tiffany,


    i wouldn't recommend using code,
    i'd use vlookup formula in the consolidation sheet,
    sort out the removed clients and delete them manually

    Re: Delete Empty Lines In Vbe


    Quote from Dave Hawley

    just Export all modules and Import back in



    hi Dave,


    i considered doing that, but i want to output the code in a userform textbox
    so that i can see the codes straight away.


    i'm not sure how to Import into a textbox, hence the big workaround :smile:

    hi guys,


    i'm trying to tweak Chip's code (http://www.cpearson.com/excel/vbe.htm) to include the body of the module as well.
    it works, but when there's blank lines in-between modules it'd show less of the modules.


    is there a way to delete the empty line in VBE?
    or did i miss something out in the code below?


    thanks for any advice in advance
    :thanx:

    hi guys,


    sorry if the title may seem inappropriate, but the problem is just that
    my excel formulas suddenly insist on using semi-colons ; in the formulas instead of the usual commas (,)


    has anyone encountered this before?
    could this setting be reversed?



    thanks for any suggestion given
    :thanx:

    Images

    • formula semi-colon instead of comma.GIF

    Re: A Basic Macro Code To Increment A Cell From 0 To 20


    hi,


    welcome to Ozgrid.com


    you can use a spinner from the forms toolbar.
    right click the spinner, select format control,
    change max value to 20 and link the cell to A40.


    hope this helps

    Re: Right-click Menus Compiler Add-in


    Quote from Jack in the UK

    The add items code is very cleaver and worth a look. Good set up front end also. Many thanks


    jiuk


    hi Jack,


    thanks for the great feedback, means a lot to me :p


    its my pleasure Derk :)


    :thanx: