LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 385
Default Column REferencing is out of wack

Whenever I run this code I can get ColREf to set itself (11) and then when I
do a mouseover I get the same value as part of the XlRng4 definition. But
when I run it I get a selection that is wrong. It keeps setting itself to
selecting Column 8 instead of Column 11.

Any ideas?

Dim ColREf as Integer
Dim Xlrng4 as Range
ColRef = xlApp.Rows(3).Find("1/1/2005").Column
Set xlRng4 = xlApp.Range(xlApp.Cells(4, ColRef), xlApp.Cells(zz, ColRef))
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing every nth cell in a new column AmyP324 Excel Discussion (Misc queries) 1 February 25th 10 01:50 AM
Referencing date column A & time column B to get info from column TVGuy29 Excel Discussion (Misc queries) 1 January 24th 08 09:50 PM
Referencing whole column Christina Excel Discussion (Misc queries) 3 November 23rd 07 10:36 PM
Referencing a column across worksheets Bob Excel Worksheet Functions 1 July 11th 06 11:27 PM
Referencing Any Cell in a Column L.A. Lawyer Excel Programming 3 October 23rd 04 02:06 AM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"