Posts by skywriter

    Quote

    Ozgrid was once the busiest excel forum on the net, unfortunately there were a number of factors that led to its decline in numbers


    Maybe things like this led to it.

    Quote

    Oh stop being such a drama queen Ali, its getting tiresome.

    Yes, people come primarily for the content, but a badly designed interface does put some off (I have seen this happen on other forums, so I know it can influence the membership to some extent). I hope that the current interface here, which is badly deigned (my opinion - your mileage may vary), will be tweaked based on the feedback offered so far.


    I agree.
    I'm hopeful also, but there seems to be too much of the sorry this version doesn't do that or it requires coding that may not stick with upgrades or updates or whatever.

    My pleasure, thanks for the feedback. :cheers:


    I just noticed there's an error in the ElseIf line, if you read this just change it to look like the other line.
    In other words change the C10 part to match the other line that looks at what is in C10, D10 etc.

    Code
    1. Cells(10, c).Value

    I think this is what you are asking for. :cheers:

    You can try this, it's untested as I don't have a sheet to test it with and I'm too lazy to create one. :cheers:


    Maybe something like this.

    wilsti6 welcome to the board.
    I'm not sure why you triple posted the same subject.
    Please take a moment to read the rules you agreed to when you joined this board.
    You should be able to edit your post if you make a mistake, or if you have to add to your original post do so in a separate post below the original, do not create new threads.
    If you have issues send a PM to a moderator and we'll be happy to assist you in any way we can.


    Thanks for your cooperation. :cheers: