vba copy

Hi All I have a workbook, and I have included comments throughout the workbook symbolised with "xxxFH: comment", in which the comment varies depending on what I'm trying to comment on in that specific row. I've got a lot of them throughout the workbook. I've basically included an additional...

Hi everyone, I'm trying to copy the range of the second table (green background), however I can only get it to copy the blue background table. I was trying to set it up so the "LastRow" was set to the row that the string "Total" is located. Which worked for my first function addSetB, which...

Hi, I am trying to figure out on how to copy a 'range'/'list' in column A to the next column B and then copy the same range/list A minus one selection to the end of column B (after the first copy) and so on , until the range in A is finished/ has reached its end. example Col A 15901 14901...

Hi guys, What I am looking to do is copy data from one sheet to another, however I only want it to copy columns A and B based on the cell value of Column E in each row So far I have the following code which is able to copy the data, but currently pastes it on every column on the worksheet and...

Hi all, I have the following code: If Not Intersect(Selection, ActiveSheet.ListObjects(1).DataBodyRange) Is Nothing Then<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;"> Dim CopyRownr As Long CopyRownr = ActiveCell.Row -...

Hi Guys, I'm aware there is tons of information on the net about this and I'm sort of biting the bullet asking such a generic question. I have a spreadsheet which is a template at the beginning of its life so there is literally no data in there what so ever. I'm wondering if someone could help...

Hi there, I am trying to copy some data a file called "Excel Macro.xlsm" to a file called "BCH.xlsx" but cnt seem to manage it. The original file "Excel Macro.xlsm" contains 2 sheets: master and BCH. I have placed a button in the 'master' sheet which should extract cells A1:E20 from the BCH...

hi, I was hoping someone might be able to help shed some light on the following. When I execute the following macro a new workbook (containing a single worksheet). However, I've noticed that when I execute the macro the name of the new workbook (containing a single worksheet) that appears...