Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel VBA - activecell.text

Posted on 2006-10-31
1
Medium Priority
?
1,732 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 500 total points
ID: 17842283
replace the 2 lines by this one:

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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Introduction to Processes

876 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