Search : in
By :

Naming range in a macro

Last answer on May 6, 2009 6:21:04 am BST kingsley, on May 4, 2009 10:16:14 am BST 
 Report this message to moderators

Hello,

I am tyring to name a range say a14:d14 (working_cap_formula) and then copy of past into range a15:d15 (working_cap_paste).

I have set up a macro to do the sopy and paste process but would like to name the range in the macro to ensure if rows are deleted or inserted above row 14 then the macro will still find the ranges to copy from (working_cap_formula) and paste to working_cap_paste).

thanks

Configuration: Windows XP Internet Explorer 7.0

Best answers for « naming range in a macro » in :
[VBA] Deleting a word in a range of cell Show[VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Forcing a domain name with the hosts file Show[Networks]Forcing a domain name with the hosts file Intro Locating the hosts file Tips Intro The hosts file primarily allow you to manually set the IP address for a host present on the network spotted by a domain name.
Download Multiple File Search and Replace Show
Download Macro Recorder Show
Download Namo Freemotion ShowNamo FreeMotion 2008 helps you to create quickly and easily Flashmovie, animations and effects. It offers different effect animations, templates, tools and wizards to simplify the task. It also includes the automatic code completion, information...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
DNS (Domain Name System) ShowWhat is DNS? Each computer directly connected to the Internet has at least one specific IP address. However, users do not want to work with numerical addresses such as 194.153.205.26 but with a domain name or more specifically addresses (called...
Ask your question Reply

1

 mubashir aziz, on May 6, 2009 6:21:04 am BST

Suppose your data is in Range A3 to onward so using this formula in

=OFFSET(Sheet1!$A$3,0,0,COUNT(Sheet2!$A:$A),1) or you can use countA function if don't have numerics ..... this will work out dynamically








Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz
Ask your question Reply
They need your help