PC Review

Reply

Rate Thread

converting ways of referencing cells

keith

Guest

Posts: n/a

15th Apr 2009

Hello,

I have a cell reference that is in the form
Sheet1!$C$4:$C$44
and need to convert it to the form
Sheet1!R4C3:R44C3

Is there a simple programming method that will make the change for me?

Keith

Reply With Quote

Reply

« Registry Location for ActiveX for Excel 2007 | textbox value »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: converting ways of referencing cells	Dave Peterson	Microsoft Excel Programming	1	15th Apr 2009 03:57 AM
Ways to parse cells in mulitple selected locations	Nature	Microsoft Excel Programming	0	18th Jul 2008 05:00 AM
Fastest ways to trace formulas (especially when cells link to otherworksheets)	Dave K	Microsoft Excel Discussion	4	8th Feb 2008 04:06 AM
referencing cells in relation to named Cells	partyof4	Microsoft Excel Discussion	1	11th Oct 2006 04:25 AM
referencing cells in Excel and finding empty cells	mgoold2002@hotmail.com	Microsoft VB .NET	1	30th May 2006 12:49 PM

Features

Forums Startup Database Reviews Articles FAQ / Guidelines About Us

Advertising

Newsgroups

Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware

All times are GMT +1. The time now is 04:46 AM.