excel 2013

  1. derek.hughes

    Ron DeBruin email worksheet code compile error - Help!

    I am in office 2013 (32x). When I run this macro: (https://www.rondebruin.nl/win/s1/outlook/amail1.htm) in Excel 2013 (works in 2016) - I keep getting a compile error at "Environ$". I've searched the web for hours and cannot figure out how to resolve saving the temp file. This is on a network...
  2. S

    Include values of cells as an array in a formula ????

    It has been a while since I posted. I have a formula that references some values in a range. The range is static and the values are constant. The formula is in cell E3. I would like to remove the values from the range and hard code them into the formula so that I don't have to have the values...
  3. G

    How do I make my excel spreadsheet take an un-organized column and group it into several small lists with a formula?

    So I'm trying to find a formula to make my Excel spreadsheet take a very un-ordered list(Column B), and sort of compress it into several ordered lists automatically. Current Example Desired Outcome A B A B 1: John - Apple...
  4. mehidy1437

    Adding more column in the arguments in VBA

    hi, how can I add column 1,2,3 here instead of column 3 only? I want to compare three column to get the unique value. str=ar(i, 3) Full Code Option Explicit Sub SumandRemove() Dim ar As Variant Dim i As Long Dim j As Long Dim n As Long Dim str As String n = 1...
  5. mehidy1437

    Export each row as separate image of a selected range in VBA

    Hi Guys, I want to export each row of my selection range as separate image in VBA. Image name will be from the first column data. Like as, S1001.jpg, S1002.jpg & go on. Is it possible? If yes, give me some idea with the code.
  6. mehidy1437

    How to get the opposite cell details from range in VBA?

    Hi If my selection range is a1: e5 then with below, we can have the first cell as fCell is a1, and last cell as lCell is e5. But what if, i want to get the first column last cell as fColLastCell is a5, and last column first cell as lColFirstCell is e1? Range can be vary time to time. Its not...
  7. P

    External Table is not in the expected format - ms access 2013

    Hi. I am running the following vb command from access 2013. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "123", "c:\test\test.xls", True Access 2013 - Excel 2013 The table 123 is created but the external table is not in the expected format appears and when I click on debug...
  8. L

    Weight Break calculations - A method question

    Hey everyone, Although this account is new I have been around before and ive always gotten good answers and im hoping once again i may get some help. This question is about how to convert a single line of parameters into slightly different static parameters. I could quite easily create a...
  9. J

    Automaticallly hide specific rows based on single cell value

    Hello everybody, I've run into some problems with a worksheet that I'm doing during my internship. The idea is that based on the value of the cell CU2 I wan to hide rows with values greater than the cell value. So if CU2=3 I want to hide the rows 4-9 and so on. The easiset thing is probably to...
  10. W

    Create user-generated or auto-generated report from password-protected shared spreadsheet Excel 2013

    My healthcare facility currently used a shared, password protected spreadsheet to schedule procedures for physicians. Is there a way I can create a user-generated report (basically a daily schedule) from the spreadsheet? I've attempted to link data to another workbook and/or create a linked...
  11. D

    Run-time error '1004': Method 'Activate' of object '_Workbook' failed only on new PC

    Hi Folks, I have an old excel model last modified in 2010 that was written by a pretty decent VBA / SQL programmer who has since deceased. All our old machines are running Windows 7 professional on a 64 bit OS using 32 bit Excel 2013 (8 gb RAM). A new PC installed recently runs...
  12. C

    VBA to insert the data into the first row of the table?

    Good day guys. My problem is every time I run the macro the data is always inserted at the end of my table. Is there a way to insert it always at first then move down? Here's the code by the way: Private Sub Submit_Btm_Click() Dim n As Long With Sheets("Record") n =...
  13. Z

    VBA - Modify table data in a transpose-y way

    Hi, I have a horrible table with information which was left to me. A bit of the legacy the previous dude left. The table goes like this: <tbody> Order Material SizeA1 SizeA2 SizeB1 SizeB2 SizeC1 SizeC2 Doz1 Doz2 1234 MAT1 30 31 A AA GM GN 24 63 4321 MAT2 40 44 XL 4X MN MO 524 636 5443...
  14. S

    Worksheet change detection for macro execution, skips one macro

    Hey there! I have a few various modules depending on a- I believe simple- worksheet change detection for their initiation. The problem is that the worksheet_change seems to constantly detect a change in two of macro initiation functions and it never acknowledges the third. Heres the code...
  15. C

    VBA code for Submit/Clear Button?

    Good day guys. I'm trying to create a Data Entry using VBA code. I successfully created the User Form but I am having problem about the code in Submit / Clear button. So, basically I just want to fill up my excel sheet what ever I enter in my user form specifically in COLUMN C, I, J, and K. I...
  16. C

    Help solving VBA code to hide and unhide columns?

    Good day guys & Happy New Year! I have an excel sheet with little bit of VBA code from it to hide and unhide columns https://drive.google.com/open?id=1phpOXBmhJ35_ptgYHCQPhkRkft2APTtl. The sheet works properly but when I added another column some days of the month was hidden too. Like for...
  17. K

    DATA VALIDATION with INDEX MATCH array, possible?

    Hello all, Context: I am working on a spreadsheet for our PMO to automatically enter data from a CSV file into a large table of agent working hours, then calculate the project's budget in a Pivot Table for their reports. They have been very thrilled with the results, however, there is one...
  18. C

    Index/Match formula for specific date range?

    Good day guys. I have a sheet like this https://imgur.com/a/OXju6Bg. Is this possible when I entered date in cell E2&E3 I want the names in the range date that I entered with the value of 1 to appear in cell H3? Thanks
  19. C

    How can I link my data in excel chart?

    I want to make a chart on my data like this https://imgur.com/a/ZTQcewD. I tried inserting chart but still not able to do it. Can someone help me. Thanks.
  20. C

    Excel 2013 Compatibility Mode

    Morning, Acolleague has sent me an Excel Spreadsheet which was in compatibility mode.This has converted it to Excel 2013. The problem is that 8 rows at the top ofthe spreadsheet which were not previously viewable are now fully on display andwhatever I try to do to hide these rows it doesn’t...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top