| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste
Is there code or a formula that will return the last column with text in it?
I want to copy the same 5 columns into the LAST column of the worksheet. I would like to do this repeadetly, so the last column would change. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and Paste
Hi Mark
You can use a function Lastcol See the example on this page http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mark Vandenberk" wrote in message ... Is there code or a formula that will return the last column with text in it? I want to copy the same 5 columns into the LAST column of the worksheet. I would like to do this repeadetly, so the last column would change. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
| Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
Hybrid Mode
