excel

  1. S

    VBA : Reflection Workspace extract all screen/pages

    Hi Good People, Currently I am working on a tool that would extract Reflection Workspace data to an excel file. The proble is, there are multiple pages or screen of a specific screen. Like for example. I managed to copy the first page of the screen, then you have to press page down key inorder...
  2. M

    code to include a column or more based on checkbox

    I have this code that sends a range as a picture into an outlook email. I added checkboxes and want to be able to modify the code to send the contents in range B4:B17 and one or all of C,D, and E depending on if the checkbox is true. I have no idea how to do this, can anyone help me? Sub...
  3. M

    Add text before pasting pic in outlook

    I have the following code that works most of the times, sometimes if gives me this error when using it consecutively too quickly: Run-time error 1004 CopyPucture method of range class failed. But I guess I can live with that :( What I need is to be able to add add text before the picture in the...
  4. S

    Search for entered value in another tab

    I have a spreadsheet with multiple tabs. In the tab titled "Cal/PM", The user will make an entry in Column A, and is supposed trigger the code below: Dim Asset As String Dim spec As String Dim cal As String Dim pm As String Private Sub Worksheet_Change(ByVal Target As Range) ' Check if the...
  5. Ramadan

    Autocomplete doesn't work between pages in the same worksheet

    I have 02 issues with autocpmplete.... first - I have a worksheet with multiple pages (alomst 30 pages) and autocomplete only work in the current page but when I scroll down to insert data in a new page it doesn't work second - another worksheet with a table and I have 4 coulmn where i insert...
  6. M

    Formula to add years and months

    Hello All, What could be the formula for total years ( 8 Years, 3 Months) in the below case? Thanks in advance.
  7. G

    Why does #VALUE error in VBA function occur when creating a ReDim Matrix of Stock prices from a Named Range?

    ' Spot = Spot Price of the underlying ' K = Strike Price ' T = Option Maturity in Years ' rf = Interest Rate in decimal (i.e, for 5%, use 0.05) ' vol = Yearly volatility of the underlying in decimal ' n = Number of time steps ' OpType = 'C' for Call and 'P' for Put ' ExType = 'A' for...
  8. J

    Need VBA code to get the list of top 10 recent files from Sharepoint link on the excel ribbon as macros in excel ribbon.

    Hi, I need VBA code to get the list of top 10 recently modified files on the excel ribbon as macros in excel ribbon. The list of these files must be obtained from the Sharepoint link.
  9. E

    Splitting Ranges of Data Apart

    Hello to all who might be able to assist me and my colleagues with this. I am trying to find a way to split the ranges of numbers apart and to get each individual number that would be in that range. For instance, some of the data I am working with is: 120751.120754 120760.120764...
  10. S

    Formula for Pulling Data From Sheet 2 Based on Cell Value in Sheet 1

    In excel I have sheet 1 and 2. Basically if the cell value in sheet 1 is either (s) or (c) I want to pull a value from sheet 2 based on the (s) or (c). So to break it down in sheet one I have the baseplate geometry and it can either be sqaure (s) or circular (c), based on if that cell says (s)...
  11. N

    How to import specific data from Windows Explorer details list? (Image focal length information)

    Hello, (First; I have Office 2016 at home) I want to run a statistical analysis on my photos that I have taken over the years to see what my most used focal lengths are. The focal lenght in the EXIF data is available for windows explorer and can be seen like this: In excel, I just learned...
  12. J

    Filter ListBox on a UserForm using a ComboBox

    Hi, I created a UserForm to enter data into a worksheet. In that UserForm I have a button that opens a ListBox showing all the records stored in the worksheet. I want to filter this ListBox using a ComboBox based on my "Area" column. I populated the ComboBox using unique values from the column...
  13. Ramadan

    How to run the same macro separately in all worksheets

    I have a workbook with multiple sheets and I have a simple macro to go to the last row in the sheet Sub LastRow() Range("amberville").Select Selection.End(xlDown).Select End Sub my problem is that when i copy the macro button to other sheet in the same workbook it doesn't work unless...
  14. T

    Using Excel, I'd like to show the page number on the first sheet, where the start other sheets can be found.

    I have a few sheets that are printed together to a single PDF file. I'd like to get the page number where each sheet will start in the PDF and include it on the first sheet that is part of the larger PDF. I found this a few other things that do not work...
  15. O

    User-defined type not defined - vba/excel error

    I am getting this error message popping up in a workbook I have, but not when I am running the macro (there's only one in the workbook at the moment). The macro runs fine with no errors, but any time I enter any data into a cell in any worksheet I get this pop up error message. I've looked in...
  16. A

    EXCEL FORMULA: I WANT TO AUTO POPULATE A CELL BASED ON THE VALUE OF 2 CULUMNS

    Hello, I need help with an excel formula that will auto populate the column PRIORITY LEVEL based on columns CRITICALITY and FREQUENCY LEVEL (see attached screenshot of what should be populated in PRIORITY LEVEL column). I know that this can be done using IF function, but I can't seem to find...
  17. D

    VBA Activate Code Emptying Clipboard

    Hello All. I have a workbook into which I have placed the following code which works as it should. This was done to prevent all following instances of Excel having hidden toolbar etc when opened while this workbook is open. The code below works and allows excel to opened ok with toolbar present...
  18. N

    Accessing a named range to insert a value does not work

    0 I have a piece of code that is trying to overwrite the value in a named range, but I am getting <Object doesn't support this property or method> Sub CheckStuff() If Evaluate("Table1RowCount") > Evaluate("Table1LastRowFixed") Then ActiveWorkbook.Range("Table1LastRowFixed").Value =...
  19. B

    How to make an action optional

    VBA Newbie here; I have built a macro to copy data from one spreadsheet to another, compiling multiple sheets from the source workbook into a single sheet in the target workbook. However, the report that spits out the source workbook does not always have the same number of sheets. Is there a way...
  20. S

    Finding Largest value

    I have "Asset ID" in Column A, and "Unit ID" in Column B. See Image of sample data below. I need to find the largest unit ID for a given Asset. I found: MaxSN = Application.WorksheetFunction.Max(Range("B:B")) But this only works if there are numbers - the SN messes it up. I tried using...

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