All Questions
6,027 questions
0
votes
0
answers
17
views
Excel Macro select sheet using cell value as name in VBA macro [duplicate]
I have an excel file with multiple sheets and macros to pull data from various weblinks and csv files and compile it into a worksheet.
What i want to is edit the end of the macro so that it selects a ...
0
votes
0
answers
34
views
Dynamic Cell Height (SwiftUI View in UIKit TableView) Weird Animation
I am attempting to adjust the height of a SwiftUIView when pressing the corresponding button. However, the animation that occurs when the height is adjusted does not align with my desired behavior. ...
- 1
0
votes
1
answer
38
views
Compare a column of strings with a 5 column and 3724 rows list and return cell addresses when matching
This is a related question to excel-get-in-one-cell-all-the-cells-containing-specific-text which does the trick, but for a smaller list.
Can someone help out to find it for my 5 column and 3724 rows ...
0
votes
0
answers
19
views
Using Closed XML, how can I set a sheetview to display the desired cells when reopening in Excel when the sheet has frozen rows/columns
I have a worksheet, originally created in Excel, that has the top two rows and the first column frozen using FreezePanes.
I am adding rows to this using ClosedXML / c# and want to be able to set the ...
- 51
0
votes
0
answers
31
views
Cell numbering in Jupyter notebook
What's going on with the cell numbering in Jupyter notebook? I created a new file and loaded the cells one after another. Instead of 1, 2, 3, 4 I get 1, 3, 5, 7...
[enter image desenter image ...
2
votes
1
answer
56
views
How to use an If function with a range of cells to send an email if greater than a number in excel?
I have a list of employees A3:A23 and G3:G23 who must stay current in observations (B and H). If they go above 0 in E and K (observations Due) I want to email myself their names A3:A23 and G3:G23. If ...
- 21
0
votes
1
answer
44
views
How can I do to justify a paragraph in table cell
I am using Apache POI 4.1.2 and want to apply justification (align both sides) in a table cell. However, it is not working properly.
Adding run.addBreak(); enables justification, but it creates an ...
- 1
0
votes
1
answer
54
views
Cell conditioning based on cell value on a row to cell value on column
Above is the cell values I want to apply the condition too.
A solution that works is to create a new column using the transpose function for the row in Question is to use the cell = cell.
I dont want ...
0
votes
0
answers
15
views
Select a spreadsheet cell with the mouse [duplicate]
How can I use a User Form to select an Excel spreadsheet cell with the mouse, rather than by inputting the Row/Column values? I need an example of the appropriate User Form code to proceed.
I have not ...
1
vote
1
answer
63
views
Excell macro doesn't run while editing a cell/how to write 'save and exit a cell' [duplicate]
I'd like to know for current application and any future use if there's a way to make a macro that saves and exits editing(writing) mode in the cell. I'm just a big dum dum trying to write a 3 line ...
- 11
1
vote
2
answers
84
views
Click shape to move forward and back in cells of the same row
I have a table with data in date format (day/month/year) distributed in row 6 and in several columns that go from E6 to NE6.
That is, E6 = 01/01/2025 and NE6 = 12/31/2025.
To advance between these ...
- 11
0
votes
0
answers
29
views
Combine tables into one table using TRANSPOSE with OFFSET [duplicate]
In Excel I have many little tables with same (vertical) headers but different content. Im trying to use TRANSPOSE with OFFSET but I cant make it work. Any help on how to achieve this?
Those 3 already ...
2
votes
3
answers
62
views
What are some possible solutions to identify the next non-existing value?
I'm currently working on a scenario where I need to find the next available ID within a list of unique IDs that contain both letters and numbers.
While I have a working solution, I'm interested in ...
- 647
1
vote
2
answers
249
views
How do i use Excel Random list generation without duplicate
I want to randomly fill a table of 50 rows without duplicate with 40 name. Also, when a cell is blank, i want to omit it from the cells to be randomly filled. So it only fills 40 of the 50 cells. My ...
0
votes
0
answers
111
views
Create a border around a range if the date in a certain cell is the same as today [duplicate]
I'm using Google Sheets. My ultimate goal is to create a border around a variable range 'B', if the date in a certain cell, within a range 'A', is the same as "today".
For example:
There ...
- 1