Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding data column without changing sheets
I am on Sheet1 and I want to run this macro without changing sheets.
I am adding data column on Sheet2 using the following and the result on Sheet1. The way I am doing it now changes the displayed sheet and then returns to Sheet1. This is not what I want. TIA Worksheets("Sheet2").Select vData = Range("C" & RowStart & ":C" & RowStop).Value2 For j = LBound(vData) To UBound(vData) ChkSum = ChkSum + Val("&h" & UCase(vData(j, 1))) Next j Worksheets("Sheet1").Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding data column without changing sheets
vData = Worksheets("Sheet2").Range("C" & RowStart & ":C" &
RowStop).Value2 For j = LBound(vData) To UBound(vData) ChkSum = ChkSum + Val("&h" & UCase(vData(j, 1))) Next j Tim "Fan924" wrote in message ... I am on Sheet1 and I want to run this macro without changing sheets. I am adding data column on Sheet2 using the following and the result on Sheet1. The way I am doing it now changes the displayed sheet and then returns to Sheet1. This is not what I want. TIA Worksheets("Sheet2").Select vData = Range("C" & RowStart & ":C" & RowStop).Value2 For j = LBound(vData) To UBound(vData) ChkSum = ChkSum + Val("&h" & UCase(vData(j, 1))) Next j Worksheets("Sheet1").Select |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding data column without changing sheets
Thanks Tim, workes great!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freezing when changing a cell or adding new data | Excel Discussion (Misc queries) | |||
Changing and Adding data through ODBC connection | Excel Discussion (Misc queries) | |||
Autofill 1 column with changing data and changing range | Excel Programming | |||
Adding Column A for All sheets : Please HELP | Excel Programming | |||
Consolidate data on different sheets in a changing range | Excel Programming |