Hi! So i have a data set that is exported by a database, so can't change it's format. I have a script to copy and paste it into my sheet and it works fine:
'set the range reference variables
Set Bk = Sheet3.Range("C5") 'file path of book to import from
Set Sh = Sheet3.Range("F5") 'sheet to...
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...
Hi, hoping someone can help as I cannot find a solution at all.
I have a workbook with two sheets. One is the active data sheet (sheet 1), the other is a reference / list (sheet 2).
Sheet 2 details across the columns (C:E) the 'Types', and below each type, lists the Tasks for that type (used...
Hi guys,
I have not posted recently or worked with VBA in some time and am now trying to write this VBA program to transfer a copy of the same profile limits from a static file ("Profile" file) to a series of result files (listed as Gen5 Result files or Destination). I wrote this code but it...
Hey,
I am currently working on a macro for duplicating a worksheet and pasting specific values from it into a new column of a remaining worksheet. However, whenever I try to paste link specific values to another worksheet, I receive the message 'Run-time error '424': Object required'. This is...
Hi,
I'm attempting to copy from one file to another. Successfully. Next step is to bring (paste) it to the correct position within the file. That's failing in the last row of this code.
What could solve this issue? Support is appreciated! Thanks Hans (Netherlands).
'Transfer to another file...
Hi. I've been using VBA for about 2 weeks and I'm struggling to find a method of copy/pasting between workbooks into a specific range. I've tried multiple different methods I've found on google and from other threads on this forum, but it always fails and gives me a 1004 error at the same line...
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.