any help
On Thu, Feb 4, 2010 at 8:46 PM, ashish koul wrote:
> hi
>
> i have a input in sheet 1 and its not limited
>
> and want result in sheet2 like in col1
>
>
> regards
>
> ashish
>
--
--
Some important links fo
Thank You So Much!!!
It works great
On Feb 3, 8:58 pm, KC Cheung wrote:
> add one more dim statement as below
> Dim d1 As String
> Dim d2 As String
> Dim d3 As String
> Dim d4 As String
> Dim full_dir As String
>
>
>
> On Thu, Feb 4, 2010 at 12:44 AM, Dave wrote:
> > Thanks for the help I
Greetings,
I need help with a macro.
I use this macro in Excel 2007:
Sub ReplaceTags2()
For Each c In ActiveCell.CurrentRegion.Cells
c.Value = Application.WorksheetFunction.Substitute(c, "", Chr(10)
& Chr(10))
Next
End Sub
My data contains the markers , which I want to replace with
line
Thanks Paul. I did understand the reasoning that the macroing language
is capable of writing vairuses and other 'nasty' things.
I like your work around.
Thanks again.
--
--
Some important links for excel users:
1. F
that is the way to go but
better yet use the very hidden comand. other wise the user can still
go and unhide the sheets with macro unabled
On 2/4/10, Paul Schreiner wrote:
> The problem is this:
> Evil hackers have managed to write Malicious code and place it in Excel
> files.
> So, Microso
Hello frends.
Help me on how to change graphs in excel so that it is 90 degree rotated.
this is very important in my work, as I want to align several graphs side by
side in their rotated view.
See attached file for more details.
Much Love.
--
In fact, you can do whatever mirroring without opening worksheets in fact
the main worksheet, solve for you?
Att,
Ulisses Flores
לוהים הוא האש מכלה
-Mensagem original-
De: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] Em
nome de PWS
Enviada em: quinta-feira, 4 de
PFA from vbaexpress.com
Regards,
Alokeshwar
+1 617 710 8441
_
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know w
The problem is this:
Evil hackers have managed to write Malicious code and place it in Excel files.
So, Microsoft has made it possible for you to DECIDE if you want macros to run.
Primarily, the only time this really helps is if you don't EXPECT the file to
contain
macros, yet it does, so you can
Interesting situtaion which I sure others have come across before. I
cannot think of a solution, I wonder if anyone else has or can?
I have the requirement to not allow a workbook to be saved if a user
has not entered information into a specified cell.
I thought that is easy I will write a proced
anybody there??
On 2 Şubat, 17:21, fill brain wrote:
> Hi All,
>
> i am trying to send my sheet in the body of the mail by ms outlook..
> but i can't send it.. i was wrote a few codes and when i try it by
> codes it is write an message in body " your browser don't support
> that" it is tellin
I think you're "kind-of" right.
Really, there are two approaches to sorting
I like using a SortFlag:
SortFlag = true
While SortFlag
sortflag=false
for I = 1 to ubound(list) -1
if (list(i) > list(i+1) then
sortflag = true
tmp = list(i)
list(i) = li
hi
i have a input in sheet 1 and its not limited
and want result in sheet2 like in col1
regards
ashish
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twit
Hello Frnds,
I explained the problem in the attached sheet only. Pls look into the same
and reply me.
Pls send it vinu1sm...@gmail.com
--
Regards
Vinod Kumar
--
--
Some important links for excel users:
1. Follow u
No problem. Your file already has a blank column E, so we need to
insert 3 more columns then label them.
Sub macrotrythis()
Columns("E:G").Insert Shift:=xlToRight 'insert new columns EFG
'label the new columns
Range("E1").Value = "Txn Type"
Range("F1").Value = "Security Id"
Range("G1").Value = "Se
Dear Gopi,
Please find the attached solution as per your requirements.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Mon, Feb 1, 2010 at 12:42 PM, krishnan Gopi wrote:
> Dear Dilip,
>
> I
On Thu, Feb 4, 2010 at 6:46 PM, Ramesh-Hyderabad wrote:
> Hi Gurus,
>
> I have a requirement where I have to check for the minimum date and
> maximum date instances for each employee and concatenate both in a
> single cell as shown in spreadsheet. I have added a spreadsheet as an
> illustration.
>
Hi Gurus,
I have a requirement where I have to check for the minimum date and
maximum date instances for each employee and concatenate both in a
single cell as shown in spreadsheet. I have added a spreadsheet as an
illustration.
Request you to look into it and do the needful at the earliest.
Wit
The following code is taken from J WalkenBach's book: Excel 2007 Power
Programming with VBA. I am trying to sort the sheets of an active
workbook in ascending order. The code works but I don't understand
what the bubblesort procedure is using as a value to define what is
ascending first. At first g
Thank you Swapnil...It worked :)
On Feb 3, 11:54 am, Swapnil Palande wrote:
> Hi Ayush,
>
> Do the following steps
> 1. crate a function for your range
> ex:
>
> Public Function nRange() As Range
> 'Dim rng As Range
> 'Set rng = Sheets("M-RAW").Range("A1:A15")
> Set nRange = Sheets("M-RAW").Range
Are you working for SEO or ADSENSE?
If so Dont do this...
Google will bann
Since Excel Macro will open the links within Seconds...
Sanjoy
On Thu, Feb 4, 2010 at 10:59 AM, sreejith k.s wrote:
> Hi sandeep,
>
> i think it is very useful one but unfortunately its not working for me,
>
> can you plea
Formname.hide will hide
Minimisation option is not there
On Thu, Feb 4, 2010 at 11:42 AM, memonkavi wrote:
> dear sir
>
> how to minimize a userform in excel vb?
>
> --
>
> --
> Some important links for excel users:
Dear Kavi,
See the below link.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=165
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Thu, Feb 4, 2010 at 11:42 AM, memonkavi wrote:
> dear si
dear sir
how to minimize a userform in excel vb?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and
Hi sandeep,
i think it is very useful one but unfortunately its not working for me,
can you please help me out.
thanks in advance
On Wed, Jan 20, 2010 at 5:42 PM, Anil wrote:
> Hi Sandeep,
>
> Enter all the URLs in a column and then use the below code to open all
> the Web Pages,
>
> go to vb
25 matches
Mail list logo
