VBA for Excel Code

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Free FrontPage Templates

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

VBA for Excel Code

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> VBA for Excel Code

Page: [1]


accessman Posts: 74 Joined: 9/13/2005 Status: offline	VBA for Excel Code - 7/9/2006 15:14:25 Hi, I write VBA in MS Access .Worksheets(3).cells(p,i) = 1 .Worksheets(3).cells(p+1,i) = 2 .Worksheets(3).cells(p+2,i) = 3 .Worksheets(3).cells(p+3,i).formula = "=Sum(" & .Worksheets(3).Cells(p, i) & ":" & .Worksheets(3).Cells(p+2, i) & ")" But, the sum function doesn't work, because it only get the cells value, it needs cells name (eg. B2, B3, ...etc). I want to use cells(p,i) to represent, because I make the variable column, and rows depend on the input parameters. Please let me know, thanks.