christophe meresse

Posts: n/a

What's wrong with my code ?

Hi !

I'm trying this code but I have a code error 9
Can you help me ?

Private Sub Cmd_Valid_Click()
Dim c As Integer
c = 1
For c = 1 To 12
If Range("R28").Value = c Then
Zone = "Feuil" & c + 4
End If
Next c
MsgBox "Selected sheet is" & Zone
LaPremiereDispo = Sheets(Zone).Range("E65536").End(xlUp).Offset(1, 0).Row
MsgBox "the first cell for this month is" & LaPremiereDispo
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
Change case...help please	Terry	Excel Worksheet Functions	14	October 2nd 05 12:29 PM
Using other workbooks..	DavidMunday	Excel Worksheet Functions	2	July 1st 05 07:35 AM
Make Change Case in Excel a format rather than formula	Kevin	Excel Worksheet Functions	1	March 18th 05 08:53 PM
Opening a file with code without a set file name	jenkinspat	Excel Discussion (Misc queries)	1	March 4th 05 10:50 AM
Opening a file with code without a set file name	jenkinspat	Excel Discussion (Misc queries)	1	March 3rd 05 03:40 PM

All times are GMT +1. The time now is 06:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us