clue

Hi, I'm in the process of trying to consolidate multiple sheets into one. Sub Consolidate_Data() ' Copy Data onto one sheet Sheets("Data1").Select Range("A3").Select Range(Selection, Selection.End(xlDown)).Select Range("A3:S" & Range("A" & Rows.Count)).Select...

Need to figure out a fix but have no clue how to do so. I've used this successfully before, really need it to work. Any help is appreciated!

Head scratcher for me I'm afraid A1 - B1 If the answr is greater than zero then show the result, else show a zero Any one got a clue about this?

I remind the double quotes this time on this formula: Range("A2").Formula = "= IF(A2=0, ""Base Bid"", ""Alternate - "" & A2)" The code will not function as it is. Can anyone clue me in on what I need to change?

Hi guys, I have this book I'm working on called AZ Claim Database. Randomly (does not occur every save) it will tell me this: Sooo I press continue and rename it "AZ Claim Database 2"... This isn't making much sense to me. Does anyone have any clue as to why it would do this? It's...

The text in column A won't format as numbers. I've tried formatting it as number, using value() formula, copying/pasting with multiplication formula. Nothing is working unless i retype the number over itself. Any clue as to why this is and what a solution is? There are no empty spaces. This is...

Hi All,, This is my first post and i am hoping someone can help. I have a dashboard which represents a speedo from a car, there is one dial on this already and now i need to add another, however i have no clue as to how to do this, can anyone help? Regards :confused:

Hi Is it possible to insert a text string in a certain position each and every time ? I have a text box that has 13 lines ie string 1 - always goes on line 1 string 2 - always goes on line 2 string 3 - always goes on line 3 etc not got a clue if someone can help PS please put comments...

I am trying to change the attributes of a worksheet so that it can be edited. When I'm in the VBA editor and stepping through the code, when the code hits the SendKeys line, it wakes up the Object Browser, which is also listenig for F2 i guess. Can I get a clue as to what am i doing wrong? is...