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

[VBAuser]

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.

 

[Marcelo Branco]

This code line
ActiveCell.Value = SampleValue
assigns the value in SampleValue to ActiveCell

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

M.

 

[VBAuser]

This code line
ActiveCell.Value = SampleValue
assigns the value in SampleValue to ActiveCell

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

M.

I knew it was an asinine mistake that was causing the problem! That works, thank you!

 

[Marcelo Branco]

You are welcome and tks for the feedback

M.