Recent content by rbobcat1

Ahhh.... playing around I got it... =Sum(A2:B2)

How do I get the proper difference Cell B1 '=SUM(B2-A2) = 226,789.34 But the true answer should be 2754.86 Cell A2 has a negative number -112,017.24 / Cell B2 has a positive number 114,772.10 How do I get the proper amount of 2754.86

I deleted the current module and started over then deleted the line like you recommended and it worked Thank you.. Point... Challenge... confused.

That doesn't work either

yes and just left it as Range(":").Select but that does not work

Having problem getting the code to work to create a dark bottom border on cells I select; The Range will only process in the "A1105:G1105" row of my sheet. I want it to work on whatever Row/Cell(s) I select. >>> use code - tags <<< 'Sub DarkUnderscore() ' ' DarkUnderscore Macro ' create dark...

Can the below formula be put in VBA? I use it in a table and sometimes the formula gets accidentally messed up which causes a problem I also have to copy & paste the A? cell to hard code the number left after the date in C5 is entered. I have the formula in A5 and as lines are added it changes...

So I should have used Option Explicit? Thx

New to VBA and I cannot seem to get this to work. i am pretty sure it has to do with the first line If i enter something in column C i want it to put the date in D. Also when I change column F to 'Closed' I want it to put a date in G. >>> use code - tags <<< Private Sub...

is this what you are looking for?

2019 '=CONCAT(B2,"/",B3,"/",B4)' should do the trick Older versions '=CONCATENATE(B2,"/",B3,"/",B4)'

All great Excel Ninjas, Need help fixing this conditional format. Seems I can only get the column to highlight the letters in 'Red' that meet a certain criteria. Column B is not a Boolean search it is only the results of an output using a powershell script. How do I get it to highlight the...

I think i just answered my own question =AND(OR($B2="This",OR($C2="123"))) Is this the best formula?

wow i cannot believe i missed that. i guess i was messing with it so much i messed up. How about another one, what if there is another criteria it must meet? for instance; if column b =this and column c has 123 I have notice when trying IF and =TEXT it kind of turn numbers in to garbage (see a13)

uploaded file I even tried wildcards