How is it that you came to misplace the password? If this is not a
commercial excel file and something you lost or misplaced I would have no
issues removing the VBA password for you and returning the file to you when
complete.
Nathan
On Thursday, January 16, 2014 6:57:35 AM UTC-5, Pavan Vallur
>
> Thanks again for all of the replies, below is the code I put together to
> do this task in case anyone is interested...
>
LastRow = Range("C" & Rows.Count).End(xlUp).row
Range("A1:B" & LastRow).SpecialCells(xlCellTypeBlanks).FormulaR1C1 =
"=R[-1]C"
Columns("A:B").Copy
Colu
Thanks all, the issue has been resolved! You are all great!
Natron
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
e CurrentRegion
collection and then jump to the next but am not sure if that is really the
best way to go about this.
https://docs.google.com/file/d/0B7Wrlvw2fV31WGtLbUVycXdaT1k/edit
Thank you to any and all responses!
Natron
--
Join official Facebook page of this forum @
https://www.facebook.c
>
> *Ashish, you are awesome!*
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quic
>
> Breaking passwords is not allowed in this forum.
>
Thanks.
>
Natron
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
My apologies Anoop, I hope you can understand my code, I tried to comment
it at key locations. I attached a workbook the second go around.
On Tuesday, November 20, 2012 9:38:32 PM UTC-5, Enrique Martin wrote:
> It's better to attach the file and put you query there.
> No one gonna study this co
Glad it worked for you.
On Tuesday, November 20, 2012 1:29:45 PM UTC-5, Mangesh wrote:
> Thank you so much Natron.
>
> You have made my work very easy.
>
> Thanks again.
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RUL
Not possible to disable closing the file without a Macro.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need A
See attached, with the code I used below...there are many other ways to do
this.
'This is hooked to your Export Specific Data Button on your form
Private Sub cmdExport_Click()
Dim intStart As Integer, intEnd As Integer
On Error GoTo whoops
intStart = Me.txtStart
intEnd = Me.txtEnd
This is close and might get you a kickstart.
Sub selectme()
''
'Original Script Written by www.ozgrid.com
''
Dim rRange As Range
Dim strCriteria As String, strCriteria2 As String
Dim lCol As Long
Dim rHeaderCol As Range
Dim xlCalc As XlCalculation
2012 11:26:07 AM UTC-5, Prince wrote:
> Hi Natron,
> I hope this will help you.
> =MID(A1,FIND("*",SUBSTITUTE(A1," ","*",1),1),LEN(A1))
>
> Regards
> Prince
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussex
Works Perfectly, Thanks! Rajan
On Monday, November 19, 2012 11:40:26 AM UTC-5, Rajan_Verma wrote:
> *If words are separated by Space use this*
>
> *=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)*2))** *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
--
Join offici
I have a string such as the following two examples and want a formula to
grab the last two words.
The following formula works for me but I'm looking for other ways to do the
same.
=MID(A1,FIND("-Date",A1)+6,LEN(A1))
Any help would be appreciated
Cell A1 contains:
Reporting Period: Month-T
Thanks Daniel that works, but I'm still trying to wrap my head around
applying this format to various ranges on the worksheet.
My data I'm comparing is in Column D and F, E and Getc all the way
up to Column EK. Any pointers on skipping around with this formula?
Thanks again!
Natr
I have multiple columns (around 140) of data and need to conditionally
format the data as apposed to looping through.
For instance I have the following data in column A and B.
A B
1 10
2 1
8 4
4 3
5 6
Here is basically what I'm trying to do:
If Column A has a value Greater than Column B then cha
Thanks to both Ashish and GoldenLance. Problem solved.
--
--
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 @ htt
Thanks for the reply Ashish,
However I need to skip around a bit since not all columns need
summed.
For instance Columns 4, 7, 9 need summed but those inbetween do not.
--
--
Some important links for excel users:
1. F
I have a spreadsheet I need to have multiple items summed at the first
blank row available...the following macro works great for Column 4 as
shown below, but I need to have it run through multiple columns up to
20...I tried using an array using a for next loop on the array, but
couldn't get it fig
Wow, I like this VBA example quite a bit, the problem I provided was
indeed simplistic and would need to be modified for my intended need.
I'm fairly new at VBA and very much appreciate your skill and
knowledge. I was wondering if an array was the way to go! Thank you
Again!
On Feb 2, 3:51 am, s
Very easy to understand, and just what I needed. Thank you very much
for your time and knowledge!
On Feb 2, 12:40 am, ashish koul wrote:
> see if this helps
>
> Sub sort1()
>
> Sheets(1).Range("a1:a" & Range("a1").End(xlDown).Row).Sort
> key1:=Sheets(1).Range("a:a"), order1:=xlAscending, Header:
21 matches
Mail list logo
