Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Removing everything outside brackets in a cell

    OK sounds like youre going my route with 2 replaces. For the first replace you want to replace anything followed by an open bracket with just an open bracket. This is done by entering *( in the...
  2. Re: Removing everything outside brackets in a cell

    Another minor comment - my solution replaces the data in situ, both the others require the formula to be in a separate cell. If you want to keep the brackets my solution can be modified the use a...
  3. Re: Removing everything outside brackets in a cell

    Hi there. You can do it with 2 replaces. First, replace "*(" with nothing (leave the replace text blank). The replace ")*" in the same way. If you are wanting to do this many times, just record...
  4. Re: Custom List for Sort Order - Using Sorted Values w/ Commas

    What about recording/writing (depending on your vba skills) a macro to do those 10 steps?
  5. Re: Custom List for Sort Order - Using Sorted Values w/ Commas

    I'm not expert in using custom lists, but a quick test seems to show you are right. One way round (if you can add a helper column) would be to create your list in 1 column, and a sequence number...
  6. Replies
    2
    Views
    83

    Re: Emailing direct from Excel

    Hi there. There is a superb chap called Ron DeBruin, who has lots of guidance on things like this. Have a look at this page - one of his suggestions should do the trick for you. ...
  7. Re: Method 'ChartObjects' of object'_Worksheet' failed

    Youre welcome and thanks for the feedback.
  8. Re: Method 'ChartObjects' of object'_Worksheet' failed

    Hi there. My initial guess is that there is no ChartObjects(8). Are you sure there are 8 (or more) objects on that sheet?
  9. Re: [vba] Grab Numerous Columns & Compile Into One

    OK, so what we need is a test to see if it exists before the copy. I got this code from another thread on here:
    Public Function WorksheetExists(ByVal WorksheetName As String) As Boolean

    ...
  10. Replies
    7
    Views
    98

    Re: VBA: Append rather than copy over

    Hi there. Change
    Lastrowa = 8 to
    Lastrowa = Sheets("My List").Cells(Rows.Count, "B").End(xlUp).Row+1
  11. Replies
    4
    Views
    72

    Re: VBA instead of array formulae

    Hi there. You could add this code straight after:
    Selection.Value = Selection.Value
    Just make sure automatic calculation is on.
  12. Replies
    0
    Views
    60

    Watermark problems in excel 2007

    Hello folks.
    I have a problem with adding a watermark. I have followed the instructions given by a number of people on the web (including microsoft) and on this forum and added my jpeg into the...
  13. Re: Copy last formatted cell into another cell in the sheet

    OK, sorry. Put a Randomize statement in your rand routine like this:

    Function RandCell(Rg As Range) As Range
    Randomize
    Set RandCell = Rg.Cells(Int(Rnd * Rg.Cells.Count) + 1)
    End Function
  14. Re: Copy last formatted cell into another cell in the sheet

    I'm not sure why - in my copy of the code it returns a random one each time.
  15. Re: Copy last formatted cell into another cell in the sheet

    Hi there. With your code as it is, the activecell is not the one youve just coloured. Try modifying the last line to read:

    Worksheets("Generator").Range("D17").Value = Cell.Value 'need this...
  16. Replies
    5
    Views
    120

    Re: Variable results from a cell input

    You can do this with a VLOOKUP. In another area of your workshhet, type the value in one column (I have assumed G) and the result you want in the column to the right (H). Then use this formula in D8:...
  17. Replies
    2
    Views
    62

    Re: Could you advise on this code please

    Hi there. I have copied your code and added some notes to each line. Basically, whats its doing is every time the worksheet is changed, and the change involves only a single cell, and the cell is not...
  18. Re: Worksheet SelectionChange - Need value from previous cell (the one that was just changed)

    Of course you're right Rory - me being dim. It only needs to be:

    Dim MyCell As String
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count = 1 Then
    MyCell = Target.Value
    End If...
  19. Re: Worksheet SelectionChange - Need value from previous cell (the one that was just changed)

    Hi there. You could use worksheet change event to store the activecell value in a temporary variable (e.g. "Changes"). Combine this with a selection change event that copies Changes to MyCell. Bear...
  20. Re: Any Excel VBA or Excel functions that can help with general lottery forecasting?

    It would be possible to generate analyses such as you refer to, but if its the UK lottery, then they already give that data - see https://www.national-lottery.com/lotto/statistics

    I would imagine...
  21. Replies
    1
    Views
    113

    Re: Automatic conversion of the currency

    Hello there. I have assumed that you can insert a row at the top to hold the conversion rate. The following code will automatically fill in the 'other' column whenever a value is entered (i.e. if you...
  22. Re: VBA Code simplification - Creating folder with month/year

    oops!! Of course I should have said July!!!!!! No wonder they didn't get it! :laugh:
  23. Replies
    15
    Views
    388

    Re: code not working - HELP !!

    Hi there. Possibly the refresh is still running, and then when you re-protect it at the end of the code thats when the error occurs? If so, try inserting this line after the refreshall line:
    ...
  24. Replies
    3
    Views
    54

    Re: PostCode Extraction data

    Or this:


    =IF(ISNUMBER(--MID(D3,2,1)),LEFT(D3,1),LEFT(D3,2))
  25. Replies
    3
    Views
    152

    Re: Sub-category drop down menu

    Hi there. What you are after is a cascading (sometimes called dependent) drop-down. There are many help tutorials around, just google cascading excel drop-down. Here is one that I've used and its...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4