thank you guys that's just fine!
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.ex
hey everyone,
how can i write a macro that colors sheet tab into "red" if:
1) sheet contains "zero" string
2) sheet contains "nine" string
3) sheet contains "nine" AND "zero" strings
4) sheet contains "nine" OR "zero" strings
otherwise sheet tab color turns into "Green"
thanks in advance for y
hey guys
i have a problem decomposing cells, i'm using a table like this one :
A B
1 name1 | S1/S2
2 name2 | M1/M2
.
.
n namen | D1/D2
i want it to look like this:
A B
1 name1 | S1
2 name1| S2
3 name2 | M1
4 name2 |M2
.
.
n namen | D1
n+1 namen |D2
thanks in advance for ur help
regards
--~--
hey all ;)
i have code that uses a code to converts this table :
A B
1 name1 | S1/S2
2 name2 | M1/M2
.
.
n namen | D1/D2
' into this : '
A B
1 name1 | S1
2 name1| S2
3 name2 | M1
4 name2 |M2
.
.
n namen | D1
n+1 namen |D2
[code]
Dim Rng As Range, Dn As Range, oVal, oSp As Long
Dim
hey guys
i'm using a table like this one :
A B C D
1 familyX | value1 | value2 | value3
2 familyY | value1 | value2 | value3
3 familyY | value1 | value2 | value3
.
.
n familyX | value1 | value2 | value3
if value
last cell in a specific row
>
> U can also use filter option
>
> rgd
>
> Gaurav
>
> On Wed, Feb 25, 2009 at 11:23 AM, Lavprasad Kori
> wrote:
>
> Hi Dear,
>
> Attached herewith the file of solution of your question. In that the
> solution is in co
hey everyone
i'm using a table like this one :
A B C D
1 Main | value | value | value
2 Extra | value | value | value
3 Main | value | value | value
.
.
n Extra | value | value | value
i want to delete every cell in column "D" only when cell in column "A"
contains "Extra" value.
help plz
reg
lete Shift:=xlToLeft
> Range(MyColumn & i).Offset(0, 2).Delete Shift:=xlToLeft
>
> End If
> Next i
> End Sub
>
>
>
> On Sat, Feb 21, 2009 at 1:57 AM, Mehdi_21 wrote:
>
> > hello everyone
> > i want to delete every 2 cells in a row containing the value
hello everyone
i want to delete every 2 cells in a row containing the value "MAIN" in
column "A" , the two cells are located in the columns B and C always.
whenever we find "Main" at a row in column "A" the program should
delete value in column "B" and "C" and shift to the left the value in
c
thanks, i appreciate ur help ;)
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google
thanks ;) but i still have another problem in copying and pasting a
group of cells in a particular row, the row must start with a cell
containing the string "extra" , the code should cut a group of cell
and paste it into another group of cell.
here's the code :
Dim extra As Range
word =
Feb 2, 10:26 pm, yorkeyite wrote:
> Try
>
> Dim c As Range
> For Each c In Range("A1:H1000")
> If c Like "FF*" Then
> c.EntireRow.Delete
> End If
> Next c
>
> Yorkeyite
>
> On Feb 2, 5:55 am, Mehdi_21 wrote:
>
> > hey guys,
hey guys, how r u all?
i started a macro that imports a text file to a worksheet, it all
worked but when it comes to the part where the program must suppress
specific cells it doesn't work , here's the code, plz do help ;)
Private Sub parcourir_Click()
Dim vFile As Variant
'Showing E
13 matches
Mail list logo