content

I have a very basic question. I've pasting clipboard content to a certain sheet (Sheet5) in cell A1 (document contains more sheets). Sub Copy() ActiveSheet.Paste Destination:=Worksheets("Sheet5").Range("A1") End Sub I'm been getting a lot of 1004 errors (paste method of worksheet class...

So I have a spreadsheet set up for work, at the top are 3 main headers merged across 4-5 cells along the row, below these merged cells are non merged cells that rely on the above cell as a sort of category to allow me to filter them easily. The merged cells can only filter the content on the...

I have a macro that opens a shared workbook, renames it and saves it again in a different folder, then creates the file again in the original location for that day's work. This macro is run by different team members each day, and none of them are tech-savvy. This has been running very well for...

Hi, I have this code (see below) that edits an XML file but it overrides the changes on the original file, I've tried to add a SaveAs option without any luck? Does anyone know how this can be achieved wit the below code? oFile = DUnRefindedXML 'Create FileSystemObject for reading file content...

Hi I get invoice on pdf in image format and to do my work i need all those figures of these invoices on excel. Is there a way to do this using excel vba. I heard about one note whixh can actually help but have no idea how to copy pdf content to one note and then one note content to excel...

Hello, I am working with an Excel 2016 Worksheet that contains a 3-D Pie Chart, and I need to Protect everything about the Chart. I have highlighted all the Cells on the sheet, and "checked" the Locked and Hidden boxes on the Protection tab, and Protected the Sheet on the Review tab, but the...

Looking for an excel VBA that will assist with the following: if column A has content swap it with content in column B <tbody> FPE100<strike></strike> <strike></strike> FPE101<strike></strike> FPA001<strike></strike> FPO00111 FPE102<strike></strike> <strike></strike> FPE103...

Hi, I have the below code and I have an issue of it running sometimes when it opens the Access dB, it needs to enable content. Is there a way enable content in the below code? I have tried a couple things but I do not think whatever I tried it even close to what is needed. Sub delete()...

Dear Friends, I have a few rows & columns in a sheet where some cells contains the content from other sheet also. When I copy these content, and paste it in notepad, it gets pasted with a space of a "Tab" where as I want a simple & single space. someplace I want it after the word / number in a...

Is there a way to automatically enable content on every workbook? The instructions I find show to turn off protected view but even after doing that I have to enable content once on each workbook that I open. Other information shows to change the settings on the message bar but it never...

I have a shared worksheet that has a button that launches a user form for data entry. Most users only view the data on the sheet. Some can enable active content open the sheet, click to launch the form to add row to the sheet. I would like the button to be hidden if active content is off. Is...

Hi I have a worksheet [report] which has defining content in column A, e.g. A1 - 5 A2 - 5 A3 - 7 A4 - 8 A5 - 8 etc I need to have a new worksheet opened for each (5,7,8) and the content placed in row 10 of the tab. Please, can anyone help? Regards Small Paul.

Hi, I am battling table properties for external data refreshed in Excel. I want a table shrinking/growing to add/remove rows in a Spreadsheet. Should be possible, right? It feels like the guy at Microsoft writing this functionality got fired halfway through, and it's not finished! Has anyone...

I have a list of people in Sheet1 starting in A2 and continuing down until the last person on the list. On Sheet2, starting in A3, I have that same list. However for each populated field in column A from A3 on, it automatically creates a box around the A cell and the same B cell. So the name...

Hi I'm a brand newbie on VBA I have a workbook called "input" that retrieves information from other workbooks (a,b,c) in a excel spreadsheet, if column G, in each workbook has content on workbook "input", each column has the content from workbooks a, b and c when column G in that workbook has...

Hello! I wrote a a message some days ago getting back a partial answer only, so I post it again in a more clear form. I have an Excel workbook, containing more spreadsheets. Some of them have an identical structure of tables (from An 1 implementare to An5 – see the Dropbox link file), whereas...

For example I make something bold, and the code notices this and runs. (without change the content) I searched for it, but haven't found any information. Have a nice day!

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

I want to make a Table of content in Excel 2007. I want to have in my Table of content, sheets name with Hyperlink and with pages numbers and also all active cells in column B in all active sheets (with or without page numbers). Do you want to help me, please? Thanks in you advance

I have a large worksheet with data from Row 10 to Row 433. I need code to copy cell value (dollar amount) from column L to column O of the same row if the cell in column A contains the letter “S”. The cells that should allow for changes will have content S.1 through S.16. The other Column A...