set on / on autocalculation

E

Eddy Stan

Hi all
I am placing location name in cell c4 of customer listing sheet, where
autocalc is set to manual. If the calculation is automatic, immediately the
customers for that location will be listed below, as i have put vlookup down
there. Since autocal is manual, it is not showing for the new location.

pl help - i want to recalculate to set on / show customer by vlookup() / off

Sub showthis()

Dim sh As Worksheet
Set sh = Worksheets("Customer Listing")

lukfor = ActiveCell.Value
Worksheets("customer listing").Range("c4").Value = lukfor
Sheets("Customer Listing").Select
sh.Calculate

End Sub
 

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

pulling cell "value" 2
Auto Calculate selected worksheets 5
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 0
Pivot Table..getting a list of all, sourec odata and sheets locate 4
OLEObjects - Paste combobox contents to a sheet 4
Private Sub Workbook_newsheet 5
Finding content of cell in visible "protected" sheets 4
macro to select range from active cell range name string 2

Top