Search:
Type: Posts; User: Steffen92
Search:
Search took 0.02 seconds.
-
Hi Westconn1,
Thanks so much. I found 1 small error, but now it is a elegant code.
code:
For rw = 5 To 23
Worksheets("Overzicht").Range("F" & rw) = 0
Next
For Each ws In...
-
Hi,
I found the solution and felt like sharing this with you. Probably not the most 'sexy and refined' code, but it does the job. Maybe someone has a tip on how to shorten this code:
Sub...
-
Hi Guys,
I really hope someone can help me out on this relative simple VBA code (simple for more experienced users, which I am not).
I want to consoildate the data from specific cells (always...
-
-
Hi all,
felt like sharing the solution. The formula which i have used in the conditional formatting is: =AND(IF(($Z7>$Z6);TRUE;FALSE);IF(ISEVEN(ROW());TRUE;FALSE);IF(ISBLANK($Z6);FALSE;TRUE))
...
-
Hi Westconn1,
would you be able to show me how it's done by sharing some printscreens? Thanks!
-
Hi Westconn1,
I want to format the cells in advance so that the formatting rules apply even after adding a new row. To get a better understanding on my challenge: this file will be used by...
-
Hi Westconn1,
Thanks for your reply. I am not quite sure that this will allow me to work with intermitted data (even and un-eve rows).
The following functions came to my attention. Do you know...
-
Hi westconn1,
did you attach something in your previous post? I am seeing 'Attachement 180082' but was not able to open the file...
-
Hi westconn1,
as this file will be used by multiple colleagues, i am afraid that the formatting will get lost by colleages copy and pasting new rows's. Besides i do not quite know how to format a...
-
Hi jmcilhinney,
as is said, i am relative (very) new to VB and also this forum. I will be running this in the Excel add-in. Is there more information you need to know in order for you, or others,...
-
Hi all,
I would like to do some VB coding where a relative simple date comparison leads to a formatting result. In the screenshot below there are 6 project represented on the A column. In the...
|
Click Here to Expand Forum to Full Width
|