paste range

I've got a workbook with 48 used columns. Of those 48 used columns I need to select and copy a range covering the contiguous first 29 columns. I need to be able to select which row to start the range on by using an inputbox and a find/match loop until the given string is found and a cell address...

Hello, I have a macro that copies a range of cells (I can’t create it as a table, because some cells are merged) and pastes it to a Word. I can’t paste it as image neither because it needs to be able to be modified later in Word. I want it to keep the columns width, it works fine except when...

Hi everyone, I am attempting to construct a code that will cycle through all sheets in a workbook (except for the first two), finding a range in each, copying that range and then pasting it to a specific workbook based on a case. I keep getting an error message. Public Sub newcopy() Dim...

Hello, I am working with three workbooks with one summarizing the two. Basically this VBA just removes subtotals, clears contents, brings over new data and puts back the subtotals. I am curious if someone could assist in helping me fix the paste error I am getting when I attempt to paste from...

I have an excelsheet with a certain range "realusedrange" that has to be pasted in a Powerpint-slide. Because I want to give the user the possibility to make complete the range I made a commandbutton on the excelsheet. When the user presses this button another macro should be started where the...