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
0
votes
0 answers
How to fix Excel ScrollBar when sheet direction is set to RightToLeft?
I have a problem when I scroll the sheet left and right in Excel 2019 and the scroll bar does not work properly with the direction of movement and jumps to another place!
This problem only occurs when my sheet direction is set to …
Saeed MJ
- 1
- 2
0
votes
3 answers
Get the reverse index of a value from Array in VBA
I have an integer array.
Dim a as Variant
a = Array(1,2,3,4,1,2,3,4,5)
Dim index as Integer
index = Application.Match(4,a,0) '3
index is 3 here. It returns the index of first occurrence of 4. But I want the last occurrence index of 4.
In python,…
usmanharoon
- 173
- 2
- 13
0
votes
0 answers
Invalid Use of Property when Calling public Function
I'm trying to code a very simple little function in VBA for Excel and it has not gone well. I don't have consistent access to Excel so I can only work on it here and there. Debugging has been hell and only managed to get it working through the VBA…
0
votes
0 answers
Add Yes text base on condition and freeze the value no mattar what
I am working warehouse and I have to tick and cross on the paper if the item is back or not. but I want to make it easy using Excel.
I manage to create a function where if Search cell and the tracking ID is matched and then display the text word…
K G
- 1
- 2
0
votes
0 answers
Is it possible to replace ScriptControl in VBA to another valid object?
I am running a macro which is using ScriptControl and parsing data with JSON. Now I need to get rid of ScriptControl due the security policies in the company. Microsoft is not updating ScriptControl anymore and to run the macro I need to install one…
David Knight
- 49
- 5
0
votes
1 answer
Paste formatting loses formatting in excel
I have two excel sheets (excel 2019)
source_file.xlsx. You can find my source sheet here
dest_file.xlsx
Am trying to split the data from source_file.xlsx and save it as multiple dest_files such as
dest_file1.xlsx, dest_file2.xlsx,…
The Great
- 7,215
- 7
- 40
- 128
0
votes
1 answer
Sum based on pattern match for multiple rows
I have an excel input data like below
purchase revenue FY_1920 FY_2021 FY_2122
PID21 kids & adults (KA) 75 75 80
PID21Elderly and old (EO) 75 75 80
PID76Men or boys 80 75 80
PID52 Women or…
The Great
- 7,215
- 7
- 40
- 128
0
votes
0 answers
I want to compare e remove duplicates of copied values in VBA
I have a question about the macro that I am running. I want to copy / paste the values cross sheet, but the target sheet I want to compare the values and remove duplicates of intercalated columns.
So, the copy and paste is working well, but to…
David Knight
- 49
- 5
0
votes
1 answer
Copy-Paste above row's Range if a specific range is empty and another is not
I have a table in an active worksheet.
I am trying to:
Scan Columns(A:M) of Row 6 to see if all cells are empty
If yes, then scan Columns (N:R) of Row 6 to see if all cells are empty
If 2. is false, then copy above row's Columns (A:I) in Row…
stavrosb
- 3
- 2
0
votes
1 answer
I want to get the file on directory counting 21 previous days from today
I have a directory with subdirectories that contains monthly files archived.
I want to get the data from files from subdirectory counting 21 previous days from today and if is not in my current subdirectory, then skip to previous subdirectory.
The…
David Knight
- 49
- 5
0
votes
2 answers
Is there a way to get the date from unix server?
I am pulling some data using VBA and the range where I need the date and time is like a huge number and it is not able to format as yyyy/mm/dd, it is like that: 1651680385.
I tried formula or change the format in Excel but, it doesn't work.
Below is…
David Knight
- 49
- 5
0
votes
0 answers
How can I get a named variable to evaluate in excel 2019? I want its value to change from time to time
I prefer not to use VBA (trying to keep this simple). How can I get alpha to be evaluatable in the enclosed excel snapshot? Thank you. MM
Mary A. Marion
- 780
- 1
- 8
- 27
0
votes
1 answer
Wrong nested IF formula
I use two formulas for my purpose:
In B2: If string start (begins) with substrings combination, then delete first substring
=IF(SUM(COUNTIF(A2;{"Not";"Bad"}&"…
Losai
- 329
- 2
- 9
0
votes
1 answer
Adding and trimming spaces before and after separator
If string contain text with one single special character (separator),
How to ad a space after point before separator and trim any space after separator?
Exemple string:
.Dolo.rum ipsum primos@ ar.deo
J.ust. simple text@ h er.e
Another fr.e.e @. exe…
Losai
- 329
- 2
- 9
0
votes
0 answers
Unable to get the Vlookup property of the worksheetfunction class error
I am trying to run some macro with the following code but it shows me the message "Error 1004 Unable to get the Vlookup property of the worksheetfunction class error" ... how can I correct this error ?
Sub GenerateReport()
Dim summary: Set summary…
David Knight
- 49
- 5