Search results for query: *

Hi, How do you format a cell to remove the "$" sign? Thanks! I know this is probably a very simple answer for most of you advanced people. Thanks!

Hi I was wondering if it was possible to put a For Statement with in a For Statement. Example: With For For If Endif Next Next End With

Hi I'm trying to build a macro that will find a string, but the string can be 5 different things. So how do I get it to find the cell that contains this information and use the information to paste in another cell. Below is the code I have that keeps getting me an error: Dim Space...

Thanks! Do I have to designate that b should be replace what was in the active cell or will it automatically assume that?

Hi I was wondering is it possible to use Vlookup formulas in a Macro? If so how? So many questions today... Thanks!

Hi, I'm having an issue with concatnation. I'm trying to take an active cell and add a "-" sign behind it. This is my code, but I keep getting an "object required" error. Dim b As Variant Set b = ActiveCell.Value Dim neg As String Set neg = "-"...

Okay I'm getting an error. This is the code I'm using: Dim nm As Name For Each nm In ActiveWorkbook.Names nm.Find("Atlanta").Select ActiveCell.Offset(0, 2).Font.ColorIndex = 3 If ActiveCell.Value = 0 Is Nothing Then Else...

Thanks for your help and explanation! Now that I created these ranges is there a way to call each of the ranges and do a For Each statement? Or do I actually have to type For Range "Apples"...?

Thank you sooo much! It worked =) Just curious but how do you learn to program like this and understand all the errors? Also how do you interpret this code ActiveWorkbook.Names.Add _ Name:=Replace(.Cells(1, 1).Value, " ", "_"), _ RefersTo:="=" & ActiveSheet.Name &...

Thanks...I tried running it using the code but I it had a problem because rng was not defined so I added Dim rng as Range, but then I had another error when I got to the ActiveWorkbook.Names.Add _ Name:=.Cells(1, 1).Value, _ RefersTo:="=" & ActiveSheet.Name & "!" &...

Well I have an excel spreadsheet I receive every month and on it are sections that are separated by one blank row but the number of sections varies. Now for each section I want the macro to choose the cell that contains the title of the data set and name define it. The Instructions sheet...

Hi I just joined this forum and this is the first time I've ever really used a forum so I'm not sure how this works. But can someone help me with trying to figure out how to make this macro, which I'm also new at since I've never really programmed before. Below is the code: Dim s As...