converting to range datatype

**ballack** · 06-12-2007, 06:33 AM

How can i convert the following to range type?
Cells(OldTargetRow, 1) to Cells(OldTargetRow, 50)

I want to use the WorksheetFunction.CountA .
Since this function takes range as variable i must somehow convert Cells(OldTargetRow, 1) to Cells(OldTargetRow, 50)
to range.

can anyone help me with this?

Thank you.

**avveerkar** · 06-12-2007, 07:47 AM

Originally Posted by ballack

How can i convert the following to range type?
Cells(OldTargetRow, 1) to Cells(OldTargetRow, 50)

I want to use the WorksheetFunction.CountA .
Since this function takes range as variable i must somehow convert Cells(OldTargetRow, 1) to Cells(OldTargetRow, 50)
to range.

can anyone help me with this?

Thank you.

Please Login or Register  to view this content.

A V Veerkar

**ballack** · 06-12-2007, 08:22 AM

When i use

Range( Cells (OldTargetRow, 1), Cells(OldTargetRow, 50))

I am getting application-defined or object defined error.

why is this?

**VBA Noob** · 06-12-2007, 08:26 AM

Please wrap your code or this thread will be deleted

VBA Noob

**ballack** · 06-13-2007, 02:52 AM

When i use

Please Login or Register  to view this content.

I am getting application-defined or object defined error.

why is this?

**royUK** · 06-13-2007, 03:03 AM

have you declared OldTargetRow as a variable and determined a value for it?

**ballack** · 06-13-2007, 03:09 AM

Yes, i have declared oldTargetRow as a Static variable as follows.

code:

Please Login or Register  to view this content.

**ballack** · 06-13-2007, 03:11 AM

Sorry,the code is as follows:
I have declared the oldTargetValue as static variable.

Please Login or Register  to view this content.

**royUK** · 06-13-2007, 04:38 AM

You give it a value after you have used it. Try

Please Login or Register  to view this content.

converting to range datatype

LinkBack

Thread Tools

Rate This Thread

Display

converting to range datatype

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions