View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nitn28@gmail.com is offline
external usenet poster
 
Posts: 32
Default VBa code for index(linest)



What exactly are the NROWS and NCOLUMNS you want? NRows I guess is the span
from R to R[2], so if you define a Long or Int variable nRows, the right
part of the above becomes:


thanx Mr. Jon for ur time n effort

wel by nrows and n columns i mean

i want to calculate equation coefficients for unknown set of X,y data

plz stil if its unclear plz let me know

many thanxin advance