# Search:

Type: Posts; User: Kamolga; Keyword(s):

Page 1 of 6 1

1. ## Thread: Code to get worksheet name into a cell

by Kamolga
Replies
11
Views
177

### Re: Code to get worksheet name into a cell

You just need to save as since the formula is based on filename, then any calculation will update the value.
2. ## Thread: SUM of cells that contain data

by Kamolga
Replies
6
Views
225

### Re: SUM of cells that contain data

Basically you just need to select 12 sheets (click sheet 1, press shift, then sheet 12) and type formula to have the count on 12 sheets. Sheet1:Sheet12 to have the count of 12 seets.
3. ## Thread: ROI value for an investment portfolio.

by Kamolga
Replies
9
Views
212

### Re: Trying to obtain the ROI value for an investment portfolio.

You are welcome, thanks for the feedback
4. ## Thread: Code to get worksheet name into a cell

by Kamolga
Replies
11
Views
177

### Re: Code to get worksheet name into a cell

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
5. ## Thread: ROI value for an investment portfolio.

by Kamolga
Replies
9
Views
212

### Re: Trying to obtain the ROI value for an investment portfolio.

One thing could be that March is text. You need to enter it as 01/03/2019 and use format, more number format, select the last one 'custom' and Type "mmmm" (without " "). So you will read March but...
6. ## Thread: ROI value for an investment portfolio.

by Kamolga
Replies
9
Views
212

### Re: Trying to obtain the ROI value for an investment portfolio.

Hi, this would sum what is in column A if the date in column E is bigger or equal to 1st July 2019 and and smaller than 1st August 2019

...
7. ## Thread: ROI value for an investment portfolio.

by Kamolga
Replies
9
Views
212

### Re: Trying to obtain the ROI value for an investment portfolio.

Nobody can add an attachment to their post.
There are tools to copy-paste excel, I installed an add-in for that but the simplest way is to use the snipping tool (installed with windows) to select...
8. ## Thread: Probability

by Kamolga
Replies
7
Views
225

### Re: Probability

You are welcome. Thanks for the feedback.
9. ## Thread: SUM of cells that contain data

by Kamolga
Replies
6
Views
225

### Re: SUM of cells that contain data

If you have columns A,b,c and rows 1 to 18, then your workdays are the amount of cells filled with data in range B1:C18

=Count(B1:C18) will count it for you.
10. ## Thread: ROI value for an investment portfolio.

by Kamolga
Replies
9
Views
212

### Re: Trying to obtain the ROI value for an investment portfolio.

It is difficult to understand what your error could be since we have no data. Are A, F and J percentages? If so can you add them (all same base)? If not percentages, you miss brackets to get a...
11. ## Thread: Probability

by Kamolga
Replies
7
Views
225

### Re: Probability

You need to first split your 3 criterias. Calculate how many females over total people. I would use
countif(A1:A99;"Female")/count(A1:A99) formula if people sex was in column A, from row 1 to 99....
12. ## Thread: automatically delete empty rows when transfer data from userform to sheet1

by Kamolga
Replies
3
Views
144

### Re: automatically delete empty rows when transfer data from userform to sheet1

Dim lr As Long: lr = Cells(33, "C").End(xlUp).Row 'Last Row

Range("A" & lr + 1, "E32").Delete
13. ## Thread: automatically delete empty rows when transfer data from userform to sheet1

by Kamolga
Replies
3
Views
144

### Re: automatically delete empty rows when transfer data from userform to sheet1

This checks what is the last row in column A above row 33, so lr =22 and then delete the range (A23:E32)

Dim lr As Long: lr = Cells(33, "A").End(xlUp).Row 'Last Row
Range("A" & lr + 1,...
14. ## Thread: VBA - Shared file. Two users with different versions of Outlook

by Kamolga
Replies
2
Views
55

### Re: VBA - Shared file. Two users with different versions of Outlook

99% work on both (only a function created after 15.0 would not work on 15.0 and they are quite rare).
What is annoying is that the outlook object library has to be activated on each computer...
15. ## Thread: Access Query

by Kamolga
Replies
3
Views
213

### Re: Access Query

should give you the list of Agent that have CNG as supplier. You might have duplicate agents because every time it reads CNG in supplier, it gives the 'agent' value...not all the records but all the...
16. ## Thread: Messy code problem

by Kamolga
Replies
8
Views
127

### Re: Messy code problem

I thing changing Textocolumn with split(expression,delimiter,[compare]) would reduce execution time. The best way is definitely to put in an Array and print it the way you want -> maybe use a...
17. ## Thread: Messy code problem

by Kamolga
Replies
8
Views
127

### Re: Messy code problem

Rows("1:3").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
to

Rows("1:3").Insert
18. ## Thread: Messy code problem

by Kamolga
Replies
8
Views
127

### Re: Messy code problem

This is just a recorded macro...indeed needs a lot of cleaning. Anything finishing with
.select and starting with
Selection. should be united.

Which line blocks?
A dirty way is to start the...

by Kamolga
Replies
1
Views
131

20. ## Thread: Text formula - reverse word

by Kamolga
Replies
3
Views
152

### Re: Text formula - reverse word

This is finally how I did it:
Since the number of parts was variable, I had more ifs that I could handle. Instead I used VBA to split my string at each "
» " into an array. With Ubound I can...
21. ## Thread: Text formula - reverse word

by Kamolga
Replies
3
Views
152

### Text formula - reverse word

Hi,

I face an issue with imported text over a few hundreds lines:

One cell (A1) is like this

Belgium BE » Flanders VLG » Antwerp Province VAN » Arrondissement of Antwerp 11 » Antwerpen 11002...
22. ## Thread: Limit users to combobox list

by Kamolga
Replies
4
Views
100

### Re: Limit users to combobox list

Create your MsgBox if something is left blank with focus to that place, so as a user you do not even need to look what is wrong...or simply use
23. ## Thread: VBA Help Needed - User form closed when other excel workbook is closed

by Kamolga
Replies
1
Views
141

### Re: VBA Help Needed - User form closed when other excel workbook is closed

ActiveWorkbook.Close

by Kamolga
Replies
4
Views
100

Maybe

25. ## Thread: number separation

by Kamolga
Replies
12
Views
318

### Re: number separation

That is how I would do it:
Put the values to split in A1, A2,A3, etc.
Select the cells I want to split, then
1.in data tab, click on Text to columns
2.Select delimited and click next
3.In...
Results 1 to 25 of 150
Page 1 of 6 1