The Excel-2019 tag is used for referencing the spreadsheet component of the Microsoft Office 2019 suite released 1 Oct 2018 (Commercial preview released 27 April 2018). The version independent Tag is "excel". If it is about an Excel formula or worksheet function, then tag it "worksheet-function". If the question pertains to VBA code, the "vba" tag should be used in addition to this one.
Questions tagged [excel-2019]
183 questions
-1
votes
1 answer
Excel 2019 VBA SaveAs generates runtime 1004
I want to save an Excel file to XLMS.
In office 2010 - 2016 this code works but in 2019 I get runtime error 1004.
I searched the internet for a solution.
I get the error on the SaveAs line.
Dim Wb As Workbook
Dim NewFileName As String
Dim…
Jorgen69
- 1
- 1
-1
votes
1 answer
My question is how can i set stop data entry when i exceed the limit of 3 countifs of same participant?
My question is if I entered "JOHN" 4 times then show me a error or stop message
"You exceed more than 3, Enter a new name"
"max of participants list is 3"
Amarendra Deo
- 55
- 1
- 9
-2
votes
1 answer
How can i get the #DIV/0! error to calculate?
I am trying to calculate the ratio between two numbers when one is 0 .
Currently, this formula produces a blank cell, can anyone tweak it to allow it to calculate even if there is a 0 present?
This is the current formula…
Insider
- 95
- 12