Solved

Excel VBA - activecell.text

Posted on 2006-10-31
1
1,704 Views
Last Modified: 2012-06-22
Range("H3").Select
ActiveCell.Text = "Totals"

what's wrong with this line. It gives an error on the 2nd line. All what i want to do is to write the text "totals" in the cell "H3".
0
Comment
Question by:sergeiweerasuriya
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 17842283
replace the 2 lines by this one:

Range("H3").Value2 = "Totals"
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question