Search:

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

Search: Search took 0.00 seconds.

  1. Re: Function .Activate and .Close not working on Mac/Excel 2016 - workaround?

    thanks, will try that :)
  2. Re: Function .Activate and .Close not working on Mac/Excel 2016 - workaround?

    That works, wohoo! However, now I get the "Grant access" request caused by Apple's sandboxing, as well as the "There is a large amount of information on the clipboard. Do you want to be able to paste...
  3. Function .Activate and .Close not working on Mac/Excel 2016 - workaround?

    Hi team,

    I have a Macro that runs like a dream on a PC, but on the Mac (which is the computer I use) it does not. I've traced it to the two lines highlighted in red. The macro runs when I remove...
  4. Re: VBA for copy/paste to different sheet with loop

    footoo, that works like a charm. Thank you so much for your help :)
  5. Re: VBA for copy/paste to different sheet with loop

    Yes and yes :)
  6. Re: VBA for copy/paste to different sheet with loop

    To illustrate where the next data is, I amended the code:


    Sub LM_data()
    Dim d As Variant, i%
    d = Array("C153", "C155", "A229", "A230", "A232", "B229", "B230", "B232", "F229", "F230", "F232",...
  7. Re: VBA for copy/paste to different sheet with loop

    There is data from 48 subjects in the sheet “Data”. The next subjects starts 130 rows after the first. I’d like to copy and paste the data from all 48 subjects to the sheet “Summary”.
  8. Re: VBA for copy/paste to different sheet with loop

    Thanks footoo. Yes, B2 is skipped.

    I've run the code:



    Sub LM_data()
    Dim d As Variant, i%
    d = Array("C23", "C25", "A99", "A100", "A102", "B99", "B100", "B102", "F99", "F100", "F102",...
  9. VBA for copy/paste to different sheet with loop

    Hi guys,

    I'm new to VBA macros and cannot figure out a way to add a loop to my macro.
    I have data output from an experiment and want to do the following:


    Copy/paste data from sheet "Data"...
Results 1 to 9 of 9