Posted to microsoft.public.excel.programming

Todd[_5_]

external usenet poster

Posts: 28

create macro

Hi, I am trying to make a macro that looks into a range
of cells I select and adds to a forumla. I have worked
something up but it doesn't work. Can someone help?

Thanks,

Todd

I have:
=IF(Ds140,ROUND($E14*Ds14,0),"")

I want:
=IF(DS14="","",IF(DS140,ROUND($E14*DS14,0),""))

The macro I am working with is:
Sub ReplaceDataTEST()
Selection.Replace What:="IF(DR140", Replacement:="IF
(Ds14="","",IF(Ds140", LookAt:=xlPart
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Create a macro to create excel line graph with coloured pointers anddata lables	anuj datta	Charts and Charting in Excel	1	September 30th 09 04:04 PM
Can someone create this macro for me Please?	Aussiegirlone	Excel Discussion (Misc queries)	1	July 25th 09 12:48 PM
create a macro	trinab	Excel Discussion (Misc queries)	1	September 30th 08 11:13 PM
How to create a Macro..	Johnny	Excel Discussion (Misc queries)	0	November 21st 07 06:47 PM
Using a macro to create a macro in another workbook	Gizmo63	Excel Worksheet Functions	2	May 15th 06 09:48 AM

All times are GMT +1. The time now is 05:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us