| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a column heading and using the column position
Nearly got there! Code: -------------------- 'In main workbook, find which column to paste data into Windows("Stores.xls").Activate Sheets("Till0" & TillNumber).Select Range("A1").Select 'Search for the Cap Date Cells.Find(What:=CapDate, LookIn:=xlFormulas, SearchFormat:=False).Activate Dim CapDateCol As Range CapDateCol = ActiveCell.Column -------------------- The only thing i can't do is go to a certain cell to paste in my data. I'm in the correct column after doing the search. I just need to go down to a row named "Zero" Any ideas? Thanks! -- drucey ------------------------------------------------------------------------ drucey's Profile: http://www.excelforum.com/member.php...o&userid=32553 View this thread: http://www.excelforum.com/showthread...hreadid=534529 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want column heading non-scrolling and rows of each column scrol | New Users to Excel | |||
| Sum column based on column heading | Excel Worksheet Functions | |||
| In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
| Find Column heading and then Delete entire column | Excel Programming | |||
| Need Macro to Find Column Heading -- if none, then insert new column | Excel Programming | |||
![drucey[_31_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
