Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > microsoft.public.excel.programming > #109448 > unrolled thread

Macros to Refresh all filled Cells.

Started byAkash Maheshwari <maheshwari.akash@gmail.com>
First post2016-10-23 04:36 -0700
Last post2016-10-25 03:20 +0100
Articles 4 — 3 participants

Back to article view | Back to microsoft.public.excel.programming


Contents

  Macros to Refresh all filled Cells. Akash Maheshwari <maheshwari.akash@gmail.com> - 2016-10-23 04:36 -0700
    Re: Macros to Refresh all filled Cells. ddxanh2613 <ddxanh2613@gmail.com> - 2016-10-23 15:25 +0100
    Re: Macros to Refresh all filled Cells. dienmaytrangiaabc <dienmaytrangiaabc@gmail.com> - 2016-10-24 04:29 +0100
    Re: Macros to Refresh all filled Cells. dienmaytrangiaabc <dienmaytrangiaabc@gmail.com> - 2016-10-25 03:20 +0100

#109448 — Macros to Refresh all filled Cells.

FromAkash Maheshwari <maheshwari.akash@gmail.com>
Date2016-10-23 04:36 -0700
SubjectMacros to Refresh all filled Cells.
Message-ID<c4ed751f-893f-4a79-ae26-72cde442ed18@googlegroups.com>
Hi,

I have used a concatenate function for clubbing two cell values. After clubbing the value is =Sheet1!D2.

I have used paste special as values in 50 Cells in a sheet.

The problem is after paste special, values =Sheet1!D2

I have to press F2 function and press enter to refresh the cell. 

Is there any macros which can refresh all the filled cells in a sheet.

Thanx in Advance.

Best Rgds

Akash Maheshwari

[toc] | [next] | [standalone]


#109449

Fromddxanh2613 <ddxanh2613@gmail.com>
Date2016-10-23 15:25 +0100
Message-ID<ddxanh2613.12528358@excelbanter.com>
In reply to#109448
We're a few weeks away from electing a new president from a pool of two
unlikable candidates.




-- 
ddxanh2613

[toc] | [prev] | [next] | [standalone]


#109452

Fromdienmaytrangiaabc <dienmaytrangiaabc@gmail.com>
Date2016-10-24 04:29 +0100
Message-ID<dienmaytrangiaabc.12533a28@excelbanter.com>
In reply to#109448
Úp cho Bác mua nhanh bán đắt




-- 
dienmaytrangiaabc

[toc] | [prev] | [next] | [standalone]


#109468

Fromdienmaytrangiaabc <dienmaytrangiaabc@gmail.com>
Date2016-10-25 03:20 +0100
Message-ID<dienmaytrangiaabc.12547d98@excelbanter.com>
In reply to#109448
Úp cho Bác mua nhanh bán đắt




-- 
dienmaytrangiaabc

[toc] | [prev] | [standalone]


Back to top | Article view | microsoft.public.excel.programming


csiph-web