Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Visual Basic displaying....

Status
Not open for further replies.
swiff

swiff

Technical User
Apr 28, 2001
2
0
0
AU
Hi there,

As a novice...

How do I display a value into an Excel Cell??

Is this right?

for example:

Sheet1.Range("B" & n) = n

Cause it doesn't work...

any ideas...

thanks a lot

Jacintha
 
Sort by date Sort by votes
Like this:
Sheet1.Range.("A1").Value = 1

OR

Coord = "A1"
Sheet1.Range.(Coord).Value = 1
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
160
marty1944
marty1944
VisKataboman
  • Locked
  • Question
Linear Column Gauge measurement form on Visual Basic 6.0
Replies
1
Views
79
xwb
xwb
2009luca
  • Locked
  • Question
DISPLAYING pdf in picturebox
Replies
9
Views
158
sal21
sal21
NewAccount13
  • Locked
  • Question
How to use Split function with Unicode Delimiter in Visual Basic 6
Replies
6
Views
90
strongm
strongm
MAVTCR
  • Locked
  • Question
Visual Basic 2017
Replies
1
Views
51
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top