Hi Team, posting on behalf of client - Macro Code refreshes a selection

Query : Do we have the same code for macro where it refreshes a selection? As per client, the file has a multiple tab. Upon checking, there are the available macro code that we have :

- "WorkspaceRefreshAll" - refreshes all workbooks in the current instance of Excel.
- "WorkspaceRefreshWorkbook" - refreshes current workbook(if workbook name was not specified as a parameter)
- "WorkspaceRefreshWorksheet" - refreshes current worksheet(if worksheet name was not specified as a parameter)
- "WorkspaceRefreshSelection" - refresh current selection(if selection address was not specified as a parameter)

Can you please help how to write a proper code / script for this please. (i.e. of the tab name is

CHF_CF_Calib)

Find more posts tagged with

excel

vba

workspace

#technology

Accepted answers

All comments

Jirapongse

@MRCHDLM

Thank you for reaching out to us.

Please refer to the answers on the following discussions:

MRCHDLM

Hello @Jirapongse, thank you for responding! Kindly need your assistance once again as client have a follow up on this.

Can you confirm if this is the correct macro code?

Application.Run "WorkspaceRefreshSelection", True, 6000, Sheets("NOK_CF_Calib").Range("J8:J17")

Additionally, client is also asking for a quick call on this. Can you please join the teams call to further assist the client on this?

Jirapongse

@MRCHDLM

Please refer to this answer.

These macros are part of the Workspace Excel product. Please reach out to the Workspace Excel team to join the Teams call.

EXPLORE OUR SITES