Hi,
I am attaching a file which is based on the same logic. U can use the same
logic for your requirement.
Hope this will help u.
Regards,
Deepak Rai
On Tue, Nov 10, 2009 at 12:11 PM, RolfJ wrote:
>
> Assuming that your country column is column A, place the following
> code into the VBA sect
Hi Tommy
Where did you get the code "name.copy" ? It doesnt work that way.
Its very simple
just write Range("a1")=name
when you use "=" operator, the value on the right hand side is assigned to
the variable on left side"
2009/11/9 Tommy
>
>
> I need to be able to insert text into a cell usin
Hi,
I would like to know if this is possible in excel 2007 and any
pointers where to look.
- I have a block of cells (like a sort of table) which I want to
define as one object (is there any way I can do this)
- Is it possible somehow with a single function to copy this object
(or block of cells
Dear Dilip,
Again many thanks for your answer, it helped my a lot to solve my
problem.
Apologies, in first I tried to generalize too much, and I wasn't very
clear ( and my bad english doesn't help)
By the way, even if your syntax helped my, I can't managed to get your
formula working
Maybe if y
On Sun, Nov 8, 2009 at 9:11 PM, Dilip Pandey wrote:
> Dear Mahesh,
>
> Attachment is solved as per your requirement. Thanks.
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 10/29/09, Mahes
Hemant,
I was hoping someone would come up with an answer for you!
I have an application that stores the entire workbook as data in
Oracle tables.
the actual "document" is retrieved and re-assembled.
If changes are made, the Oracle database is updated.
Now, users sometimes want to make cells bo
ASSUMING that column "A" ALWAYS has data,
then you could use:
'---
Private Sub Worksheet_Change(ByVal Target As Range)
If (Application.WorksheetFunction.CountA(Range("A:A")) = 10) Then
MsgBox "You