Hi

if you want to search blank value in the cell (C11) in all the sheets and
enter values into it then

Try

Sub Mtest()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Range("C11").Value = "" Then ws.Range("C11").Value = "ABC"
Next ws
End Sub

HTH
Mahesh

On Sat, Sep 24, 2011 at 11:33 PM, Mahesh parab <mahes...@gmail.com> wrote:

> Hi
>
> Try
>
> Sub Mtest()
> Dim i As Integer
> Dim ws As Worksheet
> Worksheets(Worksheets.Count).Activate
> For i = 1 To Worksheets.Count
> 'Change sheet name where you want to copy data from all other sheets
> If Sheets(i).Name <> "Mainsheet" Then
> 'change you range here
> Sheets(i).Range("A1:A25").Copy Destination:=Sheets("Mainsheet").Range("A" &
> Rows.Count).End(xlUp).Offset(1)
> 'OR if header of all sheets are common and used rows are 25
> 'Sheets(i).UsedRange.Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count -
> 1).Copy Destination:=Sheets("Mainsheet").Range("A" &
> Rows.Count).End(xlUp).Offset(1)
> End If
> Next i
> End Sub
>
> HTH
> Mahesh
>
> On Sat, Sep 24, 2011 at 4:44 PM, naanu v <naanu2...@gmail.com> wrote:
>
>> I have around 100 sheets .
>>
>> I want to search blank value in the cell (C11) in all the sheets and enter
>> values into it
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to