screenshot

Hello all, Currently I have and excel coversheer made and the ribbon and other parts are completely hidden to make a clean experience. Hidden by Application.ExecuteExcel4Macro "show.tpolbar(""Ribbon"",False). What I am looking for is a way to utilize a function in the ribbon while it's...

Hi there, I have seen posts on how to screenshot a full page from Excel into a PowerPoint presentation. Which works as expected. I am very new to VBA and cannot figure out how to select a range and paste the range into PPT. Any pointers? Thanks ESEM

Hi, I am sure, that I am missing something silly which is stopping me from getting the desired result. This formula is a small part of a project that I am working on. Can someone please look at the screenshot, and tell me what I am doing wrong? Condition: If C3 = NA and D3 ="" then E3 should...

Hi I want to take screenshot of a range and expect a prompt to save it. The range is not always same. The maximum range is same... means there wont be more than 11 rows and 10 columns. But, I only want to take screenshot of the range having data. That is less than or equal to 11 rows. Number of...

Hi! I have a custom google map with thousands of pins and thousands upon thousands of data points in an XML file. I'm trying to get them to display all nicely in a normal spreadsheet so I can sort and analyze the data. I'm having trouble with the final steps when I'm importing the XML file into...

Hi Lovely people, Can someone please help me with this I need a formula in I14 to match the I12 with row2 AND I13 with row 3 and E14 with A4:A9 and bring me the corresponding value. Please have a look at the small screenshot I've attached in the below link. Cheers...

How do I do in Excel to copy data diagonally Tex as in the picture text that is marked with red color I want to copy from all cells Ex, screenshot what i mean https://imgur.com/a/IWW9sVP thank you

I would like to save userform as an image inside .xlsx file. I have button in userform to save as .xlsx. So my code should take a screenshot, create new Excel file, paste screenshot in there and save newly created Excel file as and .xlsx file on users desktop. For some reason my code does not...

I'm really new to VBA coding and would highly appreciate if you can help me with the error as per the screenshot <a href="https://ibb.co/hmRVfHr"><img src="https://i.ibb.co/ZM6xmKv/Compile-error.png" alt="Compile-error" border="0"></a> https://ibb.co/hmRVfHr

Hi: My apologies for presenting a screenshot but this is all I have access to. I am trying to fill dates in column A. The expected results are shown in screenshot. The simplest way to explain: For every blank cell or group of blank cells, copy date above the blank cell into the blank cell...

Hi. Some background. I work on a vessel laying subsea cable on the bottom of the ocean. Usually we need to draw this cable position in XY, and also in Z. For the position in Z, we generate a profile view along the XY position. Giving the orange line in the attached screenshot. However, since...

Hi guys, I'm scratching my head a little bit with this error. The VBA code I have, which pastes a screenshot, is as below. What I'm finding is that it is very temperamental. Some days the code works fine. Other days it comes up with the error as shown in the title. After pasting the screenshot...

Dear all, I am having one excel file with vba in which some cells are protected (white) and others are unprotected (sky blue) within a specified range (print area) I want to take screenshots by double clicking on each protected cells in the range and which leads to popup msg of protected...

Hi all, I was wondering if you could help me identify on what formula to use in order for me to count absences for each month and at the same time will accumulate that number. So say, the sheet will count all the absences that the person made and if he/she accumulated more than 3, then the...

I can't figure out why the sheet has a split between columns on the page. I've ruled out page breaks and print area. If I drag it the divider it gets worse. What is it and how do I get this sheet to display, neat and clear, without all those other areas in the display? Here's a screenshot...

Hi, I have this macro (see below) that allows me to take screenshot and save it to a specific path with a specific filename. For the path, it is user dependent. For the filename, it is reference to the active cell selected during the screenshot. Before I am only required to sceenshot 1 part of...

Hi All, Hope you are good. After update office 2016 I have got "run time error 53" in macros. Please see screenshot: https://ibb.co/dQX8Jd Could you please help me how to remove this error? Thanks Halid

Good day all, It has been YEARS since I used a Forum so you can guess that I have a few questions, but I will keep it to down for now. This is what I am trying to do. I am having a problem with the setup of a spreadsheet I am trying to create and I wanted to provide a sample screenshot (to the...

Hello everyone, I want to automatize my work with excel, but sumif function is giving me small issues. I provided a screenshot to explain you my problem. Can you please tell me how can I tell excel to sum all the values from "new errors" column but only if the event type is "ICH"? You can...

Hi guys, I'm having trouble adding another column for my screenshots. What I need is to be able to click the same command button then if the +5 column is occupied for it to take a new screenshot and place it in +6 column. The code below does that but it doesn't save as a new image. It...