Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    852

    Sorry I have made an error in my typing! The...

    Sorry I have made an error in my typing! The formula I was using did include the Len - i.e. =if(len(A2)>6,"A","B")

    The strange thing was that if the length was 6 it gave a result of A rather than...
  2. Replies
    5
    Views
    852

    LEN not working with IF in Excel 2007!

    I have a spreadsheet where I am trying to use the Len funciton embedded in an If statement and it does not appear to work! What am I doing wrong!

    String len len with If
    W12345 6 A
    123456 6 A...
  3. VBA case fucntoin for conditional formatting to update entire row

    I have 6 conditions so need to use the lovely case function. However, I need to colour the entire row not just the relevant cell.

    Column C contains the possibility of Conditon-1,...
  4. I thought Conditional Formatting started with...

    I thought Conditional Formatting started with 2007! - sorry I have to go back to 2003 (currently working with 2010) for a problem I am sorting for a friend. Thanks for your time.
  5. run update only on current record in continuous form

    I have a field [hyperlink] which contains a hyperlink to a folder relevant to the unique id ref field [jobs_ID].

    I have an update query which will populate the hyperlink field with the explorer...
  6. Access 2003 - alternative to conditional formatting required

    I used to have some VBA which allowed me to colour a cell [Ref] on a form where two other cells did not meet certain critera eg [amount_received] <> [amount_expected] in a particular row....
  7. Replies
    1
    Views
    3,195

    I don't want to turn off "enable editing"...

    I don't want to turn off "enable editing" globally - so would like to include a line of code when I open a particular file so that editing is enabled for the duration of the macro (it is saved and...
  8. Replies
    2
    Views
    535

    Also Excel Subtotals feature gives you the same...

    Also Excel Subtotals feature gives you the same look - Sub Totals info
    They are really useful!
  9. Replies
    1
    Views
    455

    I have a quite complex macro which is run once a...

    I have a quite complex macro which is run once a week it downloads data from an FTP source, drags that data into a series of worksheets, adding them from the first empty row after of previous...
  10. Many thanks - I thought it was me!!! Regards ...

    Many thanks - I thought it was me!!! Regards Roberta
  11. I have a shared spreadsheet with combo controls...

    I have a shared spreadsheet with combo controls which can be selected in 2003 - but in 2010, unless I remove sharing, the combo controls are not selectable.

    I have tried saving as a 2010 macro...
  12. Hi I have interited a workbook with a vb...

    Hi

    I have interited a workbook with a vb script which after downloading an FTP file which it writes to the various sheets in the workbook (this bit works a dream). It is then supposed to add a...
Results 1 to 12 of 12