WorksheetFunction does not display result

K

KatTheBird

Hi all

I am trying to manipulate a spreadsheet from within an Access module prior
to importing the data into a database table.

unfortunately the function I am trying to run does not appear to display any
results. That is, the line of code executes without any errors but I do not
receive any results in the target cell.

Can anyone suggest what I am missing??

sh2.Range("a1").Select
sh2.Range("a1").Value = Excel.WorksheetFunction.Left(Range("e1"),
Excel.WorksheetFunction.Search(" ", Range("e1"), 1))
Range(Range("a1").End(xlDown)).FillDown

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste excel from access 0
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
No response to change_event 4
Change_Event not responding to change made by formula. 11
Worksheet Change Event 10
Ignore case of text in code 4
Word Macro for multiple searches, incl. in footnotes 2
Lookup reference help 3

Top