pastestart

  1. G

    VBA Help to pass over workbook if not relevant

    Hi all, New to the forum to post but have used teh information many times, I have teh following to help populate a consolidated workbook which pulls in data from selected workbooks: Sub PopulateData() Dim wb1 As Workbook Dim wb2 As Workbook Dim wb3 As Workbook Dim wb4 As Workbook Dim wb5 As...
  2. K

    Using VBA program to copy and transpose on to new sheet

    Hello! I am trying to write a program that lets me select a file, after selection it would then open the file and copy the contents in the first sheet. From here I want the code to paste (transposed) the data on to the second sheet of that selected file. Right now, this code is pasting the...
  3. M

    How to Avoid Auto Cell Formatting

    Hello guys, i am importing data from a XML file. The contents are consists of Alpha, numeric and symbols. After importing, the cell formats are showing as General. Some of my values are like Date and Time format. After pasting, Date like values changed to 8 digit number and some Time like values...
  4. M

    Deleting a Particular Column with IF Condition before Pasting

    Hello Folks, Please go through the code i mentioned. The code is intended to copy all the sheets from source workbook and paste to another workbook's single sheet. My requirement is before pasting all the sheets it should look for E1 cell in all the sheets, IF the E1 cell is blank it should...
  5. A

    Get the address to a set PrintArea and use it for copy

    Hello, I was wondering how can I get the set PrintArea of a sheet and use that address to copy over to another sheet. Lets call the PrintArea sheet .. Sheet1 and the destination Sheet2 Sheet1 will be a sheet that has been imported from a file. The printareas are all going to be different so I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top