Help with macros, what's wrong with my code??

cc.caroline15 · #7 01-12-2015, 10:04 PM

Thank you so much!! you were a big help!!

Quote:

Originally Posted by macropod

At its most basic you could use something like:

Code:

Sub Demo()
Application.ScreenUpdating = False
Dim StrAddr As String
StrAddr = Trim(InputBox("What is the Address of cell to update?", "Input Destination"))
On Error GoTo ErrExit
ActiveSheet.Range(StrAddr).Activate
ActiveCell.Value = "=SUM(B6:E6)"
ErrExit:
Application.ScreenUpdating = True
End Sub

Note that I haven't added any code to actually validate the address.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What's wrong with my loop?	Irrma	Word VBA	2	06-17-2014 06:25 AM
What's wrong with my code?	ksigcajun	Word VBA	3	05-19-2014 06:42 AM
Wrong hyphenation	NobodysPerfect	Word	1	02-04-2014 05:46 AM
Demo gone wrong	RyanNIF	Publisher	1	10-19-2011 05:55 AM
PLEASE HELP-wrong formatting????	bruce	Word	10	04-10-2010 03:45 PM