Switch Panes Using F6 not working
I am using split panes to type a formula and I want to reference something from the top of the worksheet. When I press F6 to send me to the top pane, instead, it is sending me to the bar on the bottom of excel and the top ribbon. It is so frustrating because this worked for me before and now it is not working and is slowing me down greatly. I was wondering if anyone could help? Thank you.Excel (365 & 2016) with network information...and much more Information to Filter.
With Excel (365 & 2016) Network information, information about Local Network Connectivity, Test Connection to a Specific Web URL, WiFi SSID information ...and much more information to filter with a button. I was trying to create a tool that would allow me to filter the necessary information from all the PCs I need to work on using a USB stick. I came across an old file that I edited and added additional information to the code. I'd like to share this file (Help for self-help). If anyone finds it useful, or would like additional tips or information, please feel free to send me feedback. If it doesn't help you...just ignore it. I welcome any constructive comments. * After loading the file, be sure to activate all macros. Happy Excel-ing! 🙂
CreateObject("Outlook.Application") with New Outlook
Hello, I've just noticed that when using the New Outlook, the VBA command CreateObject("Outlook.Application") generates the following error: "-2146959355 (80080005) Server execution failed". Am I the only one experiencing this issue? Or is there a need to modify the command? This works perfectly fine on the classic version of Outlook. Thank you in advance
Macro Error for Pivot Table
I can create a Pivot Table for the data I download and it works fine. However, when I made a Macro to do the same thing, I get an error. The error is: Run-time error '5': The following is a screenshot of the highlighted error in the Macro. I am now using Excel 2013, however I made an initial Macro using an older version of Excel and am now trying to make a pivot table using 2013 and installing it near the start of the existing Macro I have. How do I correct for this error?
Best method to find variances between checkbook deposits and GL deposit transactions
I'm looking for a way to find variances between checkbook deposits and General Ledger deposit transactions. Single checkbook deposits post to the GL as multiple entries (deposits are exported to the GL from a different platform). For example, a single deposit of $10,000 in the checkbook may actually be 5 checks of $2000 each, which post to the GL individually. This wouldn't be an issue except there are often over 3000 individual GL entries and 1000+ checkbook deposits in a given month. I need to determine which groups of GL entries equal each checkbook deposit in order to find the variance. Below is a very simplified version of what I'm looking at. I have tried subtotaling by date, but this doesn't work well, because each checkbook deposit can send entries to the GL with multiple check dates. I have considered Solver, but this problem seems too complicated for that method. Is there a way to do this in Excel, or do I need something more sophisticated? I am an advanced Excel user, but the answer to my problem has eluded me, so far. Thanks for your help.
VBA help needed
Hi I am trying to create an excel spreadsheet for a football tipping competition (for family & friends) I am using Excel 365. I asked this question to an AI bot program "I have an excel sheet with 27 tables named table 1 to table 27, I need to fill a table with 27 columns and 48 rows, I can only use the names from table 1 to randomly but equally fill all 48 rows in column 1 in the table, the same with table 2 to fill column 2 and so on through to table and column 27. The names on each row cannot be repeated more than twice." It has generated this script. { "vba_script": "Sub FillTables()\n Dim ws As Worksheet\n Set ws = ThisWorkbook.Sheets(\"Sheet1\")\n Dim i As Integer\n Dim j As Integer\n Dim tableNumber As Integer\n Dim nameIndex As Integer\n Dim usedNames As New Collection\n For i = 1 To 48\n For j = 1 To 27\n Do\r\n tableNumber = Int((27 - 1 + 1) * Rnd + 1)\r\n Loop While usedNamesCount(ws.ListObjects(\"Table\" & tableNumber).ListColumns(j).DataBodyRange.Value) >= 2\r\n usedNames.Add ws.ListObjects(\"Table\" & tableNumber).ListColumns(j).DataBodyRange.Value\r\n ws.Cells(i, j).Value = ws.ListObjects(\"Table\" & tableNumber).ListColumns(j).DataBodyRange.Value\r\n Next j\n Next i\nEnd Sub\n\nFunction usedNamesCount(name As String) As Integer\n On Error Resume Next\n usedNamesCount = usedNames(name)\nEnd Function" } I am only a novice with Excel & was wondering if anyone would like to have a go at it for me. Thanks BillVBA multiple select no repeat dropdown not working
Hello, I have an excel with one column as a multiple select no repeat dropdown. It was working fine until I added a row now none of the column will allow multiple select. I have used the data validation, selected the multiple items and added the VBA again but no luck. This is the VBA I am using: Option Explicit Private Sub Worksheet_Change(ByVal Destination As Range) Dim DelimiterType As String Dim rngDropdown As Range Dim oldValue As String Dim newValue As String DelimiterType = ", " If Destination.Count > 1 Then Exit Sub On Error Resume Next Set rngDropdown = Cells.SpecialCells(xlCellTypeAllValidation) On Error GoTo exitError If rngDropdown Is Nothing Then GoTo exitError If Intersect(Destination, rngDropdown) Is Nothing Then 'do nothing Else Application.EnableEvents = False newValue = Destination.Value Application.Undo oldValue = Destination.Value Destination.Value = newValue If oldValue = "" Then 'do nothing Else If newValue = "" Then 'do nothing Else Destination.Value = oldValue & DelimiterType & newValue ' add new value with delimiter End If End If End If exitError: Application.EnableEvents = True End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub Any help is appreciated!
