UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> How can i put data in acell,what's the problem in these ways?    
 
   
ElSendrella
post Aug 29 2007, 01:31 AM
Post #1

UtterAccess Addict
Posts: 105
Welcome every body,
what's the problem in that:
Me.Cells(9, A).Value = "kkk"
Or Even:
Me.Cells(9, A) = "kkk"
As me is the worksheet, but it give me an exception of:
(Application-defined or object-defined error)


soo, what should i do?
Go to the top of the page
 
+
KingMartin
post Aug 29 2007, 01:56 AM
Post #2

Retired Moderator
Posts: 10,959
From: Prague,CZ / Kiev,UA
What value has A?

Where is the code placed?

The code itself seems to be OK.

Martin
Go to the top of the page
 
+
Clippit
post Aug 29 2007, 06:06 AM
Post #3

UtterAccess VIP
Posts: 3,645
From: Near Toronto, ON, CA
Both arguments ato .cells are numbers. If you want A9 you want .cells(9,1)
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 02:45 AM