Results 1 to 1 of 1

Thread: reading the contents(formula) of an excel cell and writing it to a second sheet

  1. Sep 14th, 2005, 11:27 AM #1
    vb_student
    vb_student is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2005
    Posts
    1,069

    reading the contents(formula) of an excel cell and writing it to a second sheet

    hello

    is it possible to read the contents of an excel cell(the contents being a formula) e.g. reading the cell A30 which has the value

    value a30 =c30*e30

    and then storing it to a variable say cellstore in VB and then writing a contents of cellstore (which should be =c30*e30) to the second sheet in the workbook

    is it possible to use say cell.formula if there is such a thing?
    Last edited by vb_student; Sep 14th, 2005 at 04:27 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width