Posts by alfadaz

    Hey all,


    I'm sure this is an easy one for some, but i've been stuck for a while on this one...


    I have a combo box, which i select an item from a list. The item selected is then set to a variable (string).


    When just doing a single match, it works fine, but if i add the OR command, i get an type mismatch error? (line 32)


    Using the watch window, everything is listed as a string. If i don't declare the item selected in the combobox, it appears in the watch window as Variant/String.


    Any help would be much appreciated...


    Thanks


    Darren

    Bit of a strange one this...


    I have a spreadsheet that i import a load of data into sheet 1, this is usually between 750-1250 lines.


    I do various things with the data and have some crosschecking to ensure all data was captured.

    I have a =sum(d:d) in a cell to total up the column, but if i click the column and check the sum of the selected cells in the status bar at the bottom, the answers are different =O


    I have checked to see if any of the numbers are stored as text. I couldn't find any...

    I have changed the formatting from General to Number, no difference...

    I have checked for hidden rows, i can't find any...


    I am now a but stuck on what to check next ||


    Any help would be appreciated..


    Thanks

    Daz


    TEST MCS_copy2.xlsm

    I am working on a project for work, where i need to create a batch file, run the file, then delete it.


    The batch file looks for text files with a set name in the current folder and subfolders and combines them into one text file.


    The batch file is running correctly, but it is running from 1 directory up.


    For example, the excel file with the VBA code is here:

    G:\Dropbox\DT\WORK\Phases - 101-102-103-104-105-106-107-108-109


    But the batch file is being created here:

    G:\Dropbox\DT\WORK\



    Any help would be appreciated...


    Thanks


    Darren

    Hi all,


    I'm looking for the best way to transpose the following data.


    Original data is the first 2 rows. The number of columns can be anything up to 15-20.


    We need the data transposed and to keep the first column data, as per the next 6 rows...
    [TABLE="border: 1, cellpadding: 0, cellspacing: 0"]

    [tr]


    [TD="width: 64"]Bay3[/TD]
    [TD="width: 150"]C1505-808A_Z-23315[/TD]
    [TD="width: 150"]C1505-808A_Z-23318[/TD]
    [TD="width: 150"]C1505-808A_Z-26330[/TD]
    [TD="width: 150"]C1505-808D_Z-26330[/TD]

    [/tr]


    [tr]


    [td]

    Bay5

    [/td]


    [td]

    C1505-808B_Z-23315

    [/td]


    [td]

    C1505-808C_Z-23315

    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    .

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    .

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    .

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Bay3

    [/td]


    [td]

    C1505-808A_Z-23315

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Bay3

    [/td]


    [td]

    C1505-808A_Z-23318

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Bay3

    [/td]


    [td]

    C1505-808A_Z-26330

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Bay3

    [/td]


    [td]

    C1505-808D_Z-26330

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Bay5

    [/td]


    [td]

    C1505-808B_Z-23315

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Bay5

    [/td]


    [td]

    C1505-808C_Z-23315

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]



    Would be prefer to do it in VBA, but not essential...


    Thanks


    Daz