Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating values with macro between worksheets
I Have the following problem: I wanted to calculate value "as" to th
column A in worksheet "Horizon_Measurements". When i try like below the code stucks i this row and appears notification of typo error. Bu if i keep on the same worksheet and calculate values to the column A everything works fine, what stucks? How i should refer to the column in sheet "Horizon_Measurements" 'This is not working If LCase(Cells(SB, "H").Value) = "as" Then Cells(SB, "Horizon_Measurements!A:A").Value = "SB203" 'This works ElseIf LCase(Cells(SB, "H").Value) = "hts" Then Cells(SB, "AB").Value = "SB501 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating values with macro between worksheets
spolk,
Change Cells(SB, "Horizon_Measurements!A:A").Value = "SB203" to Worksheets("Horizon_Measurements").Cells(SB, "A").Value = "SB203" HTH, Bernie MS Excel MVP "spolk " wrote in message ... I Have the following problem: I wanted to calculate value "as" to the column A in worksheet "Horizon_Measurements". When i try like below, the code stucks i this row and appears notification of typo error. But if i keep on the same worksheet and calculate values to the column AB everything works fine, what stucks? How i should refer to the column A in sheet "Horizon_Measurements" 'This is not working If LCase(Cells(SB, "H").Value) = "as" Then Cells(SB, "Horizon_Measurements!A:A").Value = "SB203" 'This works ElseIf LCase(Cells(SB, "H").Value) = "hts" Then Cells(SB, "AB").Value = "SB501" --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating values with macro between worksheets
Thanks Bernie! this works and again going forward toward ne
obstacles.. -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy & paste-special-values data to selected worksheets | Excel Discussion (Misc queries) | |||
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
Macro to Create Worksheets Based on Cell Values | Excel Worksheet Functions | |||
Excel VBA Macro to compare 2 worksheets for same values | Excel Worksheet Functions | |||
Calculating across worksheets | Excel Discussion (Misc queries) |