Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range calculate
hi all !!! does anybody know how can I place a -range.calculate- inside a
sub like that starts like the next one ?? .. i tryed but didn't work.. TY Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
range calculate
Hi
You don't say exactly what you want to calculate, but this is working: Sub test() Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") myResult = WorksheetFunction.Sum(aWS.Range("B2:B7")) aWS.Range("A1") = myResult End Sub If this don't help, you need to give us more information about what you want to do. Regards, Per On 16 Jan., 23:46, pls123 wrote: hi all !!! does anybody know how can I place a * -range.calculate- *inside a sub like that starts like the next one ?? .. i tryed but didn't work.. TY Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
range calculate
Sub luxation()
Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") Set r = aWS.Range("A1") r.Calculate End Sub -- Gary''s Student - gsnu200827 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
range calculate
im very sorry i need a manual calculation cycle:
Range("A1:B5").Calculate ty "pls123" wrote: hi all !!! does anybody know how can I place a -range.calculate- inside a sub like that starts like the next one ?? .. i tryed but didn't work.. TY Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
range calculate
or a
Worksheets(SheetName).Calculate ... "pls123" wrote: im very sorry i need a manual calculation cycle: Range("A1:B5").Calculate ty "pls123" wrote: hi all !!! does anybody know how can I place a -range.calculate- inside a sub like that starts like the next one ?? .. i tryed but didn't work.. TY Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
range calculate
Sub test()
Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") aWS.Range("A1:B5").Calculate End Sub Regards, Per On 17 Jan., 01:45, pls123 wrote: im very sorry i need a manual calculation cycle: Range("A1:B5").Calculate ty "pls123" wrote: hi all !!! does anybody know how can I place a * -range.calculate- *inside a sub like that starts like the next one ?? .. i tryed but didn't work.. TY Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1")- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Range | Excel Discussion (Misc queries) | |||
Calculate Range | Excel Worksheet Functions | |||
How do I calculate within a range? | Excel Worksheet Functions | |||
calculate sum of range | Excel Programming | |||
Code to calculate the first row and last row of a range | Excel Programming |