copies

Run-time error '1004': while trying to printI have created a user form were I select certain checkboxes for the sheets I want to print and then run the code below to print. If possible could someone take a look and see what I need to correct to fix this problem? Thanks for the help as always...

Run-time error '1004': while trying to print I have created a user form were I select certain checkboxes for the sheets I want to print and then run the code below to print. If possible could someone take a look and see what I need to correct to fix this problem? Thanks for the help as always...

I have created a user form were I select certain checkboxes for the sheets I want to print and then run the code below to print. If possible could someone take a look and see what I need to correct to fix this problem? Thanks for the help as always Here is the code I have Private Sub...

I'd like to track the date that an action was taken in a workbook in cell B2, but I don't want the date to update after the initial entry. Will I need to add code that copies B2 and pastes special values, or is there another alternative? I'm not seeing anything on the web that offers guidance...

Hi, I was wondering if there is a way to limit how many copies you can make of an excel file(xlsx or xlsm). (i.e. limit # of copy+paste operations carried out on a file) Thanks, Sj

I have a file that every month-end I take the last three tabs in the workbook and make copies of them in the same workbook for the next month-end. Here is the bit of code I have that seems to work to copy one of the selected sheets but just the one. Ideally I'd like to hold down control and...

Hello guys, im using this code Sub etc xLastRow = Range("A" & Rows.Count).End(xlUp).Row For i = 1 To xLastRow Columns("AO:AT").Select Selection.Find(What:="Michael", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _...

Hello everyone, can anyone tell me the following: I have a sheet with a header, and my macro is copying rows to the respective sheet but it keeps pasting over my header as i caould not find a solution to move to the next available empty row. I have tried this but it has no effect nextrow =...

I have a macro that copies certain information to the clipboard which works perfectly. This is where I need help. I need to be able to copy/paste the clipboard to a text file and it would be better if I am prompted for a location/directory in which to create the text file and for a name for...

Hello all, I have several excel files that are macro enabled with some code in them. However, I would like to save some code free copies for back up. I thought this would be as simple as saving it to a .xlsx file but that apparently doesn't completely wipe out the vba project. Is there an...

So far I have this to create sheets: Sub SheetCopier() Dim x As Integer x = InputBox("Enter number of times to copy default sheet") For numtimes = 1 To x 'Loop by using x as the index number to make x number copies. ActiveWorkbook.Sheets("Default").Copy _...

I have a macro which copies over the relevant data from one tab to a new tab within a new workbook. However, it also copies across two radio buttons which I no longer need within the new document. How do I delete these? The two radio buttons cover cells U3 to AB 20

Good Day, This is Witson, i am pretty new for this VBA. I prepare Invoices in Excel and export it in PDF and save it, as well as i print the original copy and send it to my clients. My Invoices has been already formatted in Excel sheet (Print Area has defined for each Sheet). Now the problem is...

I have a users form that contains a print macro. Included in the macro is a message box that allow the user to input the no. of copies to print. However after selecting the number of copies to print and selecting the OK button, the message box pops up again Please amend my macro to prevent...

Hi Excel Gurus :) I have googled this, but I can't seem to find what I am looking for. I want a VBA macro that takes all the xlsx files in a directory, opens, copies and pastes the content as values and closes again. Any ideas? Thank you in advance

Hi, Having a tough time creating excel files with names mentioned in a list(150 +) every month. Sure someone has an answer to help me here. Here is the scenario: I have a macro enabled workbook "Database" which collates data from several file kept in the source folder and then format the same...

Hi, I have a small problem that has been bugging me since I installed Excel 2007. If I have several cells selected and right click on the selection, Excel automatically puts this in the clipboard, as if I had chosen 'Copy' or pressed Ctrl+C, and the moving boarder appears around the selection...

I am using the below code on a userform that looks at which checkboxes the user ticked, which correspond the sheet names in the active workbook. Then prints out the sheets they selected. My problem is that I would also like the user to be able to use the userform to enter the number of copies...

I have a work in progress file on my hard drive whereby sheets are update hourly. As I'm updating the hard drive file I want another file copy or copies on a shared drive to be updated at the same time. Is there a way to automate the process without having to save as all the time. Can the...