Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.34 seconds.

  1. Replies
    20
    Views
    5,720

    Re: Automatically move rows to another sheet

    Is the below true in your case?
  2. Thread: Scorer sheets

    by MARK858
    Replies
    18
    Views
    485

    Re: Scorer sheets help

    Where did you put the code? In a sheet module or a regular module and how are you triggering it? Manually, by formula or code?
  3. Thread: Scorer sheets

    by MARK858
    Replies
    18
    Views
    485

    Re: Scorer sheets help

    https://www.darts501.com/Scorer.html
  4. Replies
    4
    Views
    186

    Re: Conversion to Mac issue with VBA

    To start with you need to change

    strPath = strPath & "\"
    to

    strPath = strPath & Application.PathSeparator
  5. Replies
    19
    Views
    367

    Re: How to copy and paste based on the headers

    When you say data, is it actual visible data or formulas returning "" or formatting? and am I correct that the publisher cell is on the ActivityTracker sheet?

    Also was any of the data hidden by...
  6. Thread: Need VBA help

    by MARK858
    Replies
    7
    Views
    173

    Re: Need VBA help

    Maybe..


    Dim fName As String
    fName = Workbooks("Filename").Sheets("TheSheetName").Range("D3").Value

    ActiveWorkbook.SaveAs Filename:="C:\Users\name\Desktop\" & fName & ".xlsm", _
    ...
  7. Replies
    19
    Views
    367

    Re: How to copy and paste based on the headers

    Only copying one column for me, you don't have merged cells do you?



    What is the row number of the last cell with data in the Publisher column?
  8. Replies
    19
    Views
    367

    Re: How to copy and paste based on the headers

    Try (untested)...


    Range(Publisher.Offset(1, 0), ActivityTracker.Columns(Publisher.Column).Find("*", , xlValues, , xlByRows, xlPrevious)).Copy
    Master.Range("C3").PasteSpecial xlValues
  9. Replies
    19
    Views
    367

    Re: How to copy and paste based on the headers

    What are you trying to get? The last used cell in the column?
  10. Replies
    19
    Views
    367

    Re: How to copy and paste based on the headers

    Try

    Publisher.Offset(1, 0).End(xlDown).Copy
    Master.Range("C3").PasteSpecial xlValues
    or

    Master.Range("C3").Value = Publisher.Offset(1, 0).End(xlDown).Value
    or

    With Publisher
  11. Thread: Need VBA help

    by MARK858
    Replies
    7
    Views
    173

    Re: Need VBA help

    So just to be clear, the code is in the workbook being saved and the cell D3 is in a workbook called "FileName" on a sheet called "OR Level Sheet".
    Correct?
    If FileName is not the real name of the...
  12. Thread: Need VBA help

    by MARK858
    Replies
    7
    Views
    173

    Re: Need VBA help

    I don't need to know that you have the VBE open or what workbooks are open.
    I need to know which workbook is active because if it isn't the one that you are saving then we need to know the workbook...
  13. Thread: Need VBA help

    by MARK858
    Replies
    7
    Views
    173

    Re: Need VBA help

    Which workbook is Active at the time of the save?
  14. Replies
    7
    Views
    2,310

    Re: VBA .find Method on Date Values

    Try

    Sub FindCell()


    Dim FoundCell As Range


    Set FoundCell = Range("A1:A15").Find(what:="10/2/2018") 'date in US format
  15. Thread: Today()

    by MARK858
    Replies
    2
    Views
    133

    Re: Today()

    Salamullah, If you are not using it in calculations can you not just use the =TODAY() and custom format the cell as either m, mm, mmm or mmmm?
  16. Replies
    8
    Views
    177

    Re: Finding last non blank cell on a row

    Try
  17. Replies
    19
    Views
    367

    Re: How to copy and paste based on the headers

    You would loop through the cells in row 8, use Find to search the first column in the table for the cells value and Offset to get the destination column name, then use the destination column name in...
  18. Re: solution for forgotten password to unprotect sheets.

    I know it wasn't a criticism, but by the way post number 1 is written I think the bells and whistles is going to be a bigger issue than getting the data (especially as it can't be fully protected as...
  19. Re: solution for forgotten password to unprotect sheets.

    As far as I know no and even if you could then telling you would at least go against the spirit at least of (and more probably directly infringe) forum rule 6.

    All I can suggest is remembering...
  20. Replies
    19
    Views
    367

    Re: How to copy and paste based on the headers

    Alex89, do you have a table with what header matches with which header as you have no consistent matching content from what you have posted, so as it stands there is not way of making a searching...
  21. Replies
    5
    Views
    179

    Re: Removing " as a Special Character

    I take it that you have tried a Find/Replace with = in the Find box (or possibly ~=) and leaving the Replace box blank?
  22. Replies
    7
    Views
    258

    Re: VBA to fill formula

    Is it erroring out and if yes is it on the line before the formulas?
    You also need to double the quotes where you have ""
  23. Replies
    1
    Views
    108

    Re: How is this a circular reference????

    What cells is the formula in?
  24. Replies
    17
    Views
    281

    Re: Tidying/Amending code

    Turning off Sceenupdating literally stops you seeing the sheet update, any interaction with the sheet slows down code and so you turn it off at the earliest point when you don't need to see the...
  25. Replies
    17
    Views
    281

    Re: Tidying/Amending code

    No it is running smoother because I moved the Application.ScreenUpdating = False.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4