e.value

Hi I have this macro that was given to me and im trying to get it set up so that i can run it on one sheet only. Sub compare_data() Dim sh1 As Worksheet, sh2 As Worksheet Dim i As Long, j As Long, lr As Long Set sh1 = ActiveWorkbook.Sheets("Sheet1") Set sh2 =...

Hi, I have the code shown below, Can you advise the correct way to write it because if my value is 4 i actually see 4$0.00 Removing the 0.00 in the code then i see 4$ I cant get it to be shown like $4 Me.txtCost = Sheets("LPM").Cells(i, "E").Value & "$0.00" Thanks

Greetings, I am having trouble with a For Loop. Everything above the For RowLoop1 = G to I line appears to be working well. I have been running it line by line with F8. At the line For RowLoop1 = G to I the code proceeds to go directly to the line K = K-1. I am not sure why the script is not...

Greetings, I am beginning to run the script below line by line with F8. I am watching the different variables with Add Watch. When I get to line: A = E The value of A goes to "0" and creates errors for the subsequent variable values that use A as an independent. Any ideas why A goes from...

Greetings, I am receiving an "object required" compile error on the line below. Set R1 = wsPA.Cells(G, "A").Row I thought .Row was an object; its a property Basically what I would like to do is loop through a range of rows defined by two integer variables, in the case of "R1" G and I as...

Greetings, I am receiving the Object doesn't support this property or method runtime error on the line below: Set CC = PA.ws.Range(Cells(G, "A"), Cells(I, "A")) I would like to establish a range variable using two cell values defined by integer variables and rows. I suspect there is a...

Greetings, Below is the line giving me trouble. I am receiving the error "method range of object worksheet failed". I = ws.Range(Cells(2, "A")).Row This line exists within the below script: Sub TRENDSHEET() Dim ws As Worksheet Dim PA As Workbook Dim TA As Workbook Dim A As Integer Dim B...

good evening trying to copy all values (numbers 1 through 4) in column e to a new appropriate worksheet. For some reason not all data is copied over. There are many spaces between rows, do not believe this is the reason? Used this code before, no issue in past. Any help would be...

Greetings, I am receiving a type mismatch error on the following line. Not sure why this is occurring. Are there limitations on the properties that I can establish within the row and column values? For instance is "A+3" as a row value not acceptable when being compared with an integer...

Greetings, I am receiving the error "Object doesn't support this property or method" on the line below TA.ws.Range("A1").Select This line exists within the code below For Each ws In PA.Worksheets A = ws.Cells(Rows.Count, "A").End(xlUp).Row Do Until A = 2 If Cells(A...