calculate range in microsoft visual basic 6.3

A

ARMANDO SANDOVAL

Joined
Sep 21, 2005
Messages
2
Reaction score
0
calculate a specific range

Hi there,

How can i calculate only a specific range, because the followings instructions does not work, and show me Error

Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate
Worksheets("sheet1").Rows(2).Calculate

I'll apreciate your help
 
Last edited:
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with macro instruction 0
Problem with .Calculate 3
clearing values of cells in named range(s) so the cells are empty 1
Retreiving Sheet1 Data Autometically Uploaded in Sheet2 2
Excel Range calculation breaking application.calculate - horrifyingproblem 8
workbook used to open but now crash with File/path error 5
How to reference a cell from anther workbook without opening it 0
Autofilter in 1 workbook and paste in 2nd workbook 11

Back
Top