python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Wrong Office version and Operating system in vba Excel
I am running this code in VBA Excel 365 using Windows 11
Sub test()
Dim sBuild As String, sOP As String, sVersion As String
sBuild = Application.Build
sOP = Application.OperatingSystem
sVersion = App...

Manuel Pérez
Votes: 0
Answers: 1
Apache-poi protect sheet locks sheet from autofilter when using Excel O365, but not when using LibreOffice
The issue
I am trying to create and populate an Excel sheet while locking specific columns and adding autofilter to the header rows.
The application currently generates the Excel sheet with the correc...
Zaccie
Votes: 0
Answers: 0
How to summarize outcomes in a spreadsheet
I have a data set (a lot more columns involved than example) however, want to summarize outcomes on a separate sheet.
Well, can’t use pivots as I have to drop data in from an external source prior to ...

user18587694
Votes: 0
Answers: 1
How to import to next empty cell / row
The code I have below works fine for importing a selected CSV file. But I want to have it so the next CSV file I import will be pasted in the next empty cell in row "U" (Basically adding on ...
Keeday
Votes: 0
Answers: 1