Refresh/Update

[hakuna]

Hi friends,
I dont get the hang of VBA inspite of having learnt C++.

anyways, i need help in coding, i want to make it possible to refresh a particular sheet on clicking a button. i can create the button and even assign the macro. but the code for macro, to refresh i don't know how to generate the code.


Thanks in advance!

 

[Oeldere]

Maybe you can record the things you do with the macro recorder.

 

[General Ledger]

Here is a macro to refresh all.

Sub RefreshAll()
ActiveWorkbook.RefreshAll
End Sub


In the past, I used this code to automatically run every time I select (activate) a sheet that had with a Pivot Table. It replaces the steps of having to select the Refresh icon from the Data or Pivot Table Ribbons.

Private Sub Worksheet_Activate()
ActiveWorkbook.RefreshAll
End Sub

 

[hakuna]

Yeah. but sometimes there is a need for VBA coding than macros.

 

[hakuna]

Here is a macro to refresh all.

Sub RefreshAll()
ActiveWorkbook.RefreshAll
End Sub


In the past, I used this code to automatically run every time I select (activate) a sheet that had with a Pivot Table. It replaces the steps of having to select the Refresh icon from the Data or Pivot Table Ribbons.

Private Sub Worksheet_Activate()
ActiveWorkbook.RefreshAll
End Sub

thanks!

 

[hakuna]

Maybe you can record the things you do with the macro recorder.

Yeah. but sometimes there is a need for <ACRONYM title="visual basic for applications">VBA</ACRONYM> coding than macros.​

 

[hakuna]

Just to add, is there a possibility of refreshing a particular cell alone??