RE: $$Excel-Macros$$ Rounding up or down

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rags R Sent: Tuesday, February 25, 2014 10:18 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rounding up or down Hi, Need formula for rounding up number (i.e. 307,077 to 307,100 & 310,0

$$Excel-Macros$$ VBA macros and Windows OS language

Hi All, I have a excel file containing various macros that provide access to the file after everyone enters their login credentials. These login credentials are included in the hidden worksheets. This file would be used by my colleagues across the world. Now my colleagues in Germany would be usin

$$Excel-Macros$$ Rounding up or down

Hi, Need formula for rounding up number (i.e. 307,077 to 307,100 & 310,000) or rounding down (i.e.304,044 to 304,000 & 300,000). Thanking you in advance. -- Best Regards Rags!!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Fac

$$Excel-Macros$$ Formula for rounding

Hi, Need formula for rounding up number (i.e. 307,077 to 307,100 & 310,000) or rounding down (i.e.304,044 to 304,000 & 300,000). Thanking you in advance. -- Best Regards Rags!!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official F

Re: $$Excel-Macros$$ need PowerPoint VBA book

Hi team, Need to excel in powerpoint.does anyone knows about any such group/forum/book like our this excellent group. I have learnt lots of cool stuff from our group.hope you all will understand my pain in making good/basic presentation. I really appreciate your help.sorry for putting this query

$$Excel-Macros$$ Webquery not using login session from IE

Hello all, I rarely post questions as I will search it out for hours. I've spent over 2 days reading every support group and no-one has seem to provide a usable response. If you are a fellow expert out there here's a challenge. USE CASE: We are running Web Queries daily to load dynamic data

$$Excel-Macros$$ need PowerPoint VBA book

Hi guys, if anyone have PowerPoint VBA book, please share. Thanks, Maksood Alam -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, a

Re: $$Excel-Macros$$ VBA Code to access pictures from drive C

i have resolved it myself. thanks for your SUPER assistance. thanks On Mon, Feb 24, 2014 at 11:29 AM, Hilary Lomotey wrote: > Thanks Boss i edited the picture and its working nicely now, so grateful > to you. i have made three images ie image1 ,image2 and image3 so that if > you select image1 t

Re: $$Excel-Macros$$ add a static text in all cells of a column

awesome sir it's is really gonna help me a lot thnx again On Monday, February 24, 2014 4:36:13 PM UTC+5:30, Verma G wrote: > > Try this > > Sub try() > Dim temp As String > Dim RNG As Range > Dim cel As Range > Set RNG = Application.InputBox("Select a range", Type:=8) > > > > For Each cel In RNG

Re: $$Excel-Macros$$ VBA Code to access pictures from drive C

Thanks Boss i edited the picture and its working nicely now, so grateful to you. i have made three images ie image1 ,image2 and image3 so that if you select image1 the others will not be seen, however the macro seem not to be hiding the other two images when one is selected. i have deleted the imag

Re: $$Excel-Macros$$ add a static text in all cells of a column

Try this Sub try() Dim temp As String Dim RNG As Range Dim cel As Range Set RNG = Application.InputBox("Select a range", Type:=8) For Each cel In RNG temp = cel.Value cel.Offset(0, 1) = "welcome" & vbTab & temp Next cel End Sub Thanks & regards, www.MrExcel4U.com

RE: $$Excel-Macros$$ VBA Code to access pictures from drive C

Its working perfectly, I am not getting whats the problem... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Hilary Lomotey Sent: Monday, February 24, 2014 3:59 PM To: excel-macros Cc: Soum Subject: Re: $$Excel-Macros$$ VBA Code to access pictures from dr

Re: $$Excel-Macros$$ add a static text in all cells of a column

Thnx Verma It is working fine can u help me a little more I want to do it by selecting a range manually (drag and select) instead of giving range in code. can we do it any help will be appreciated On Monday, February 24, 2014 3:24:01 PM UTC+5:30, Verma G wrote: > > Try this > > Sub try() >

Re: $$Excel-Macros$$ VBA Code to access pictures from drive C

EXCELLENT BOSS 100% OF WHAT I WAS ASKING FOR, THANK YOU VERY MUCH, just a slight issue, when i change a picture, it doesnt show unless you click on the picture, immediately you remove the mouse it goes off. can you help out thanks. On Mon, Feb 24, 2014 at 5:50 AM, Ravinder wrote: > [image: Boxb

Re: $$Excel-Macros$$ add a static text in all cells of a column

Try this Sub try() Dim temp As String For i = 1 To Range("A1:A10").Rows.Count ' change row count as per your requirement temp = Cells(i, 2).Value Cells(i, 2).Value = "welcome" & vbTab & temp Next End Sub Thanks & regards, www.MrExcel4U.com On Mon,

$$Excel-Macros$$ add a static text in all cells of a column

Hi i need to add a static text in all cells of a column ...can any one suggest how to do this i try this but not working Sub try() Dim temp As String temp = Cells(1, 2).Value Cells(1, 2).Value = "welcome" & temp End Sub Thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?