I want to know how to find the row number after I have used an offset from the middle of a Range. I have the code that I have been working with, just need some help to refine....
Here is the code
Code in red is where I thought I could use to split out the ROW, but that is where I don't what to do next, or maybe barking up wrong tree !!
Please Login or Register to view this content.RED does not work inside code look at "KeepAddress" line
Last edited by dkub; 05-13-2011 at 03:22 PM. Reason: Took out "RED" color on lines of code
I want to be able to place today's date in column "E" at the same ROW as the offset
Hi,
Maybe you can post a sample workbook? or have you tried Something along these lines?
.Please Login or Register to view this content.
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
Maybe, These to lines then?
.Please Login or Register to view this content.
Good Stuff - Thanks a bunch
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks