LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Difficulty with formula

I'm having a ridiculous time over a very simple thing that I should be able
to do; I want to insert the following formula and I'm using the following
function to do it:

Formula: =D5&E5;"
Render: RadioTuner;"

Dim rCell as Range
For each rCell in Activesheet.UsedRange.Columns(2).Rows
rCell.Formula = "=D" & rCell.Row & "&E" & rCell.Row & ";" & """" & ""
Next rCell

This flubs on the formula, can someone please correct my formula above so it
can be written into the sheet? Thanks...
 
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
Formula difficulty Pyrite Excel Discussion (Misc queries) 5 October 8th 08 08:13 PM
Price Function - Difficulty in understanding the formula abhi_23 Excel Worksheet Functions 0 January 18th 06 09:41 AM
difficulty with permutations, please help! Loane Sharp[_2_] Excel Programming 2 August 9th 05 05:32 PM
Difficulty with MOD operator when using Mod 1 Terry Holmes Excel Programming 5 April 27th 05 09:52 PM
AutoFill difficulty Jim Berglund Excel Programming 3 November 10th 04 11:24 PM


All times are GMT +1. The time now is 08:09 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"