Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.36 seconds.

  1. Re: VBA - Copy specific columns from sheet2 into sheet1 within the same Workbook

    First of all this

    With scrws
    is still wrong and I can't see how it would run without erring until it is corrected. It should be
    srcWS

    In this line the colored bits are declared twice which...
  2. Replies
    5
    Views
    29

    Re: Date / time conversion to dd/mm/yy

    Nothing to be sorry about :rofl:
  3. Replies
    11
    Views
    77

    Re: Removing Duplicates with Timestamp

    Removed as on testing SuzB17 appears to be correct.
  4. Replies
    5
    Views
    29

    Re: Date / time conversion to dd/mm/yy

    Edit: Too slow, deleted as no benefit over what Special-K99 has posted.
  5. Replies
    11
    Views
    77

    Re: Removing Duplicates with Timestamp

    With the original data (after the timestamp is removed) if you change the format of the cells to a number format rather than a date format what do you get returned?
  6. Replies
    14
    Views
    112

    Re: excel 2002 convert numbers to mathematical

    I think you missed the Immediate Window part, if you can't see it in the VBE click the View icon then click Immediate Window, it normally appears at the bottom of the window where you type your code....
  7. Replies
    7
    Views
    69

    Re: Help me with entering times in Excel

    Yes but the act of adding AM to the cell doesn't turn it to text, it is the lack of the space with the AM so this statement



    is incorrect.

    Data validation though from the OP's post would do...
  8. Re: "Be careful! Parts of your document may include personal information that cannot be removed by the document inspector"

    In Excel Options|Trust Center|Privacy Options try unchecking 'Remove personal information from file properties on save'.
  9. Replies
    7
    Views
    69

    Re: Help me with entering times in Excel

    halesowenmum, you can always use Data validation to force the users to enter it in a recognised time format.
  10. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    Except it doesn't :biggrin: besides obviously I would already know what outcome it gives me before I posted it.

    Anyway I already stated I can't go any further without more info or a copy of the...
  11. Replies
    7
    Views
    69

    Re: Help me with entering times in Excel

    If I enter 10 AM in a cell (with the space) it doesn't turn it into text, it remains in time format and =ISNUMBER(The cell reference) returns TRUE.
  12. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    Yes it would, one implies that it hadn't been tested.

    Afraid I have nothing to add currently as the code I posted printed out 3 pages with my data so unless you can provide any other info I don't...
  13. Replies
    2
    Views
    44

    Re: Delete entire row

    Maybe....


    Sub delrow()
    Dim x As Long
    Application.ScreenUpdating = False
    For x = Range("H" & Rows.Count).End(xlUp).Row To 2 Step -1
    If Not IsNumeric(Left(Trim(Cells(x,...
  14. Re: if date falls on weekend, roll to Monday

    See Ricks response to the OP's duplicate (well strictly speaking this was the duplicate as they posted the other thread before post number 7) here

    but the correct answer is still to enter the...
  15. Re: VBA - Copy specific columns from sheet2 into sheet1 within the same Workbook

    The main difference is the original code loops through each cell in each column and copies it whereas the amended code copies the complete range in each column and copies it in one go

    For...
  16. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    By do you mean it did just... when I tested it.... probably just the grammar but not reading right to me.
  17. Re: VBA - Copy specific columns from sheet2 into sheet1 within the same Workbook

    You haven't replaced it with what I posted... look again.
  18. Re: VBA - Copy specific columns from sheet2 into sheet1 within the same Workbook

    With scrws needs changing to
    With srcWs
  19. Replies
    9
    Views
    154

    Re: Copy & Paste Cell formats

    Your Autofilter only looks at one column... Column G.
    If you mean rows then it looks at cells that are greater than the start date so yes a blank cell will be ignored.
  20. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    What happens with...


    Sub PrintSelection()
    With ActiveSheet.PageSetup
    .PrintArea = ActiveSheet.Range("A1").CurrentRegion.Address
    .Zoom = 100
    End With
    ...
  21. Replies
    9
    Views
    154

    Re: Copy & Paste Cell formats

    If that is the result that you get with that code then your Excel is acting very oddly :eeek: how are your cells formatted? normally or with conditional formatting? and what formatting do you have...
  22. Re: if date falls on weekend, roll to Monday

    If you put the year as just 33 then the default in Excel/Windows will treat it as 1933 not 2033. The 29th July in 1933 was a Saturday.

    See the link below
    ...
  23. Re: VBA Autoprotect sheet and allow filtering

    You set up the filter dropdowns first then change


    For Each ws In ThisWorkbook.Worksheets
    ws.Protect "Password"
    Next ws

    to
  24. Replies
    10
    Views
    124

    Re: VBA filling loop

    =ISBLANK(Y26) returned TRUE and LEN(Y26) returned 0 but ran the code again after re-copying the data from post 4 and it filled Y26.... confused but not going to get to the bottom of it as it now is...
  25. Replies
    5
    Views
    105

    Re: Running a Macro Several Times

    If I am understanding correctly then maybe.....


    Sub transCode()
    Dim i As Long
    Application.ScreenUpdating = False
    For i = 2 To Sheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Row...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4