All Questions
5
questions
0
votes
2
answers
332
views
How to conditionally concatenate a range with VBA?
In my work, every end of the month I have to review data saved in spreadsheets like the image. The only data that interests me is to check the value of L column and obtain the data in the BS column. ...
1
vote
2
answers
10k
views
Visual Basic - VBA code to skip or ignore rule if cell contains certain value
I have written the following VBA code to automatically populate column "P" with "pending", "Not due","-" based on the value of column "O".
The user will manually have to enter "complete" into column "...
- 11
2
votes
1
answer
297
views
Creating a function called IFTRUE that behaves as IFERROR but for a function returning TRUE. Worsheetfunction.if doesn't work. What am I doing wrong?
I wanted to create a custom function that would be a shorthand for if(somefunction(arg)=something,"sometext",somefunction(arg)) So I don't have to duplicate somefunction(arg) each time I do this, just ...
- 774
0
votes
2
answers
4k
views
Random Numbers in a Range of Cells
I want to generate random numbers in my model. Every time I run the macro my cells range "G8:H34" have to fill in with different random numbers that should be integers from 0 to 2.
I have to ...
- 21
2
votes
1
answer
2k
views
Excel VBA code Private Sub Worksheet Change Power function not working
I'm making a worksheet where the wind speed defines the potential energy of the location. This value is the basis of a few sheets in the same Excel file. I'm trying to write a code that where I10 is ...
- 23