Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Worksheet Display Not Updating Through Loop Process

    Hi there. You have a line
    Application.ScreenUpdating = False
    in your import routine. After the first execution of it, screenupdating will be off. Either remove that line, or insert ...
  2. Replies
    3
    Views
    37

    Re: Macro for a large report

    You are welcome. If you do decide to go down that route, it would be possible to create a one-off macro that could populate the teachers names for you. If thats something you would like, get back -...
  3. Replies
    3
    Views
    37

    Re: Macro for a large report

    Hello there. Yes, a macro could well do it for you, but why not do a small redisgn of the data and then simply use a filter? You could remove the data currently in column A and instead put the...
  4. Re: Expand rows based on cell value in VBA - multiple in worksheet

    Hi there. Put this code in the worksheet code area -

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$C$52" Then
    If Target.Value = "Yes" Then
    ...
  5. Replies
    7
    Views
    78

    Re: Save Copy File as Read Only (VBA)

    Somehow the line setting the full path has been modified. Replace it with this:

    strFullPath = strTargetPath & "" & strFolderName & "" & strFileName & "." & strFileExtension
  6. Replies
    7
    Views
    78

    Re: Save Copy File as Read Only (VBA)

    Ah yes. As written, it will only work the first time the file is saved. Try this modified version:

    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Dim wb As...
  7. Replies
    7
    Views
    78

    Re: Save Copy File as Read Only (VBA)

    Hello.

    Add the line shown in red:

    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Dim wb As Workbook: Set wb = ThisWorkbook
    Dim FSO As Object
    Dim...
  8. Re: Tracing Formula Frustrations due to complex cell referencing​

    Welcome to the forum. I think you answered your own question - use names. Also, I wouldn't call it a 'limitation' rather a feature. One way to possibly help is that if you still use cell references,...
  9. Re: Logical formula for calculating until a number has been reached

    Hi there. I'm sure there will be other solutions, but try this.

    I assume your data starts in A1, and that the name and 1/3 volume are in columns D and E - if not just adjust as necessary.
    In E2...
  10. Re: Calculating multiple text boxes on a user form

    This solution will still error if TextBox9 is entered when TextBox4 is empty (you would get a division by zero error).

    So, for TextBox9 do something like:

    Private Sub TextBox9_Enter()
    if...
  11. Replies
    1
    Views
    52

    Re: Multiple ISBLANK Query

    If I understand your requirement correctly then this should do it (I have stuck to your approach although there are other ways of obtaining the same result):
    =IF(ISBLANK(B2),"CAD...
  12. Re: How many versions would you say is enough

    Hi there. This is very much like asking 'how long is a piece of string' The answer will vary wildly depending on a number of factors. I list a few here:
    -complexity of the workbooks (how easy to...
  13. Replies
    18
    Views
    322

    Re: More =IF formula issues

    Yongle You are right if the original cells were boolean values, I (maybe wrongly) thought they may be text, which, reading LiebKcir's latest post may well be the case.
  14. Re: Searching multiple values in Custom Filter

    To search for more than 2 matches at a time, you will need to either use the advanced filter or some vba. Have a look at advanced filter first. With that you can filter for many different values.
    ...
  15. Replies
    18
    Views
    322

    Re: More =IF formula issues

    Hi there. I think what is happening is that you are confusing boolean and text values at different points. If the copied values are TRUE or FALSE, these are text fields, not boolean. Typing TRUE into...
  16. Re: VBA Code to copy all files from Folder 1 to Folder 2

    Hi.

    There are many examples of how to do this on the web already. Ron De Bruin's website is one - look here for a complete solution: https://www.rondebruin.nl/win/s3/win026.htm
  17. Re: [VBA] Pivot Table make column headers show Day 12 instead of xx/xx/xxxx

    Hi there. This will produce the result you want i think:


    =""Day ""&(TODAY()-RC[-1]+1)
  18. Replies
    2
    Views
    140

    Re: Watermark problems in excel 2007

    Anyone got any insight here? Any way for me to put a watermark onto an excel page?
  19. Re: Merge Empty Cells with a cell with a date

    If the other 4 cells are ALWAYS blank (as you say), then simply sum them in column 6 and set the format of the column to what you want. The blanks get added up as zeroes, so you end up with just the...
  20. Re: Deleting a column and keeping correct formula.

    You're welcome and thanks for the feedback.
  21. Re: Deleting a column and keeping correct formula.

    Hi there. If the names start in the first column,just use the formula =COLUMN() in row 2. If the names start in a further column(e.g. it looks like your first name is in column C) then adjust the...
  22. Re: VBA split string and add to HTML body with formatting

    Thanks for the info. Peter. Now all I have to do is remember it!
  23. Re: VBA split string and add to HTML body with formatting

    Sorry. I forgot that this forum can misinterpret < and > characters. To do what you want, replace the variable forms in your output with Replace(forms,";"," < br > < br > "). Remove the blanks around...
  24. Re: VBA split string and add to HTML body with formatting

    You say it will be going into an html format. In that case, this will do it for you (change B2 to wherever your text is):

    strttext = Range("B2").Text
    EndText = Replace(strttext, ";", "<br><br>")
  25. Re: How to change dynamically excel external file name change daily as the date

    You need this to replace the red bit:

    &TEXT(TODAY(),"yyyymmdd")&
    So, the whole thing would be:

    =IF(FileExists(),VLOOKUP("NET EFFECT ON TRIAL...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4