End(xlDown).Value deletes data in a Linked table

VBAuser

New Member
Joined
Dec 12, 2011
Messages
16
Hi All,
There doesnt seem to be a post on this, and it's really probably a simple problem that is now really starting to bug me.

My VBA says:

Dim SampleNumber as Variant

Columns("B:B").End(xlDown).Select
ActiveCell.Value = SampleValue

But everytime my code executes the activecell.value line, the data in the cell that it correctly selected is deleted! Not sure if this makes a difference but I am working in a range that has a linked table.


Thanks in advance.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
This code line
ActiveCell.Value = SampleValue
assigns the value in SampleValue to ActiveCell

Don't you want the opposite?
SampleValue = ActiveCell.Value

M.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top