excel 2013

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...

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 =...

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...

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...

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...

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...

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...

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

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.

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...