Posted to microsoft.public.excel.programming

dan dungan dan dungan is offline

external usenet poster

Posts: 411

Data replacement

Thanks Dave!

On Oct 22, 1:42 pm, Dave Peterson wrote:
I'd try:

Dim n As Long 'it holds a (row) number
Dim i As Long 'it also holds a number
Dim v1 As Variant 'or string??
Dim v2 As Variant 'or String
Dim r As Range 'it's a range (a single cell) in the used range.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data replacement between worksheets	JLB	Excel Discussion (Misc queries)	2	June 26th 07 09:20 AM
Replacement	T De Villiers[_45_]	Excel Programming	0	July 21st 06 03:53 PM
Replacement	T De Villiers[_47_]	Excel Programming	0	July 21st 06 03:53 PM
Replacement	T De Villiers[_44_]	Excel Programming	0	July 21st 06 03:52 PM
Replacement or deletion of data after filter	Seeking help[_8_]	Excel Programming	0	July 6th 06 03:36 AM

All times are GMT +1. The time now is 02:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us