I'm new to Excel and I'd like to know since it's more organized are the scripts better than other programming language scripts such as Ajax, JavaScript, Java FX, etc.
View 4 Replies
i am very new to and admittantly can only use by running through the commands...i dont know how to run/use a macro with vba language...
so, i can easily set up a small macro run button that allows users to input a ''member number'' at any one time manually and it then selects the data behind that number and prints all relevant info/sheets etc,,,
HOWEVER, i dont know how to do an auto run selection in macro...so, rather than manually entering member 1, select, print, then manually enter member 2, select, print, then manually enter member 3 etc... i want to produce a macro that would automatically run the whole list of member numbers from 1 to 170 in order and print all their relevant info in one go...rather than manually entering the numbers which would take ages...
in a nutshell, select all (1 to 170), run all, print all...
I have a list of English words (about 2500) that are listed in excel in column A. In column B I'd like the Portuguese translation.
The best I've got so far is to have a hyperlink in column B -
=HYPERLINK("http://www.ultralingua.net/index.html?action=define&sub=1&nv=0&searchtype=stemmed&text=XXXXXX&service=english2portuguese",
"ultralingua").
Where I've typed 'XXXXXX' this is the word that will be translated in
ultralingua.
Is there any way that XXXXXX can be replaced with the contents of a source cell i.e. so ultralingua translates the contents of one of the cells from column A? I'll the transcriibe the result into column B.
how to change language of MS office.English language is not showing in options.Do I need to purchase language pack?I am using english language other than office.
View 1 Replies View RelatedI have a spreadsheet with thousands of rows of text that I need converted from one language to several other languages.
Is there a macro I can use that taps into some free service, running down my page and giving a foreign language conversion for each cell?
[URL]
Macro, I can make number to language. As example: 121 is one hundred one.
View 5 Replies View RelatedI have a sheet that the first words in the cells are in Arabic. How can I move the foreign words to another column? The number of words varies and they are all in the beginning of the cell.
View 7 Replies View RelatedHow to convert a numeric value into Bulgarian words in Excel?
View 1 Replies View RelatedI would like to run a macro against a worksheet that will have variations in the amount of data (rows not columns). The column headings will always stay the same.
Once the basics in the macro run (formatting) I will need a certain statement to "lookup" values in a column (see values below) "count" them and give me a total.
I have attached a before and after file showing what I would like the macro to ultimateley do because it is so time consuming. Any assistance would be most appreciated.
.083=0-2hrs
.125-.50=3hrs-12hrs
.541-1.0=13hrs-1day
1.04-5=25hrs-5days
See SLA Response Days (column)
I need to split the original sheet to many sheets according the language code, each language in a sheet.
Below the details of the original sheet:
First column for language name.
Language name always starts with two or three characters as shown:
ar
fa
fil-ph
gu
he
hi
id
[Code] .......
I need to split the original sheet to 21 sheets according to the language name ,the output sheet called by the language code name.
Also the first row in the original sheet is fixed in all extracted sheets.
LSPKG Name
New
Updated
Autotranslated
Uploaded
TopX
[Code] ........
This may be a bit of a silly question but any assistance would be much appreciated, as I cannot figure out where I am going wrong:
Dim RRR As Range
Set RRR = Range("c3").End(xlDown).Select
What I am trying to do is to create a dynamic range called 'RRR' so that everytime the macro is run, it makes sure that all the data is selected in the column.
I need to select a print area that includes all rows to the last row with data in column A. What is the proper code for this? I tried the following (shot in the dark), and of course it doesn't work.
Sub Print_()
ActiveSheet.PageSetup.PrintArea = "A( Cell((65536).End(xlUp)):X1"
ActiveSheet.PrintOut
End Sub
A co-worker has an excel file that has both English and Chinese words in it. We need to convert the Chinese text to English. The contents of the files are sensative so I cannot share a copy. how to correct this?
View 2 Replies View RelatedI have users that submit a workbook quarterly. Many of the submissions contain name ranges that I need to remove. I wrote the below to delete the named ranges but encounter an error when the macro encounters a named range with the Kanji (Japanese) character set. How can I update this to delete these ranges as well?
Sub DeleteNamedRanges()
Dim ws As Worksheet
Dim NR As Name
On Error Goto ErrTrap
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
For Each NR In ActiveWorkbook.Names
NR.Delete
Next
Next
ErrTrap:
If Err.Number = "1004" Then
Resume Next
End If
End Sub
I have attached a worksheet as my example.
I have been trying to build code and I am a newbie when it comes to this.
I have a sheet that is user entered (Criteria). I need to build a macro/code that says if they choose "Yes" to any of the Products on the criteria sheet, then copy all rows that have an X in them that are in the corresponding column on the Master Template. To make it even more complicated I only want to copy 4 of the columns (ID, Task, Share with Client and Accountable).
I know if they choose multiple columns then I could have duplicate rows, but once all the rows are copied I was going to build a remove duplicates macro. However, if there is anyway of preventing duplicates with the original.
I need help to get the macros right to do the following that it can not do now:
I would like the user to be able to pause in between input areas and do others things.
Need for the input length to be varible or grow with the information
Are these things possible?
I have only the basic knowledge of the VBA programming. Are there any books you can recommend?
View 2 Replies View RelatedI am looking for a code to generate a combinations of x numbers taken 5 at the time. t
View 2 Replies View Relatedhow to type a name into one cell and have all the places in a particular range (a1:H12) that displays that name to highlight a color.
View 14 Replies View Relatedi could create a spreadsheet with two columns one with email addresses and another with a path to an attachment
e.g. column a = example@example.co.uk
column b = c: est.xls
and then for a macro to read my data, and send an email to those email addresses in column a with the attachment of column b
I have created a userform with text boxes and a list box. I have a few questions. First for the list box. I got the information for my list box through the list box example sheet2!A1:A1000. Is there any easier way ? Next I would like to create a New Command button to create a new record. I decided to just do a clear all textboxes, option buttons ect.. to clear, is there an easier way ? I seem to be looping sort of way when I get to txtissue.Value = "" it than goes to txtIssue_Change()
View 14 Replies View RelatedI have a base list of numbers on a spreadsheet that represent specific values. For example, Column A has a list from cell 1 to 20 that contains a group of different numbers that all represent credits. Column B also has a list with different groups of numbers that represent debits. Each month I receive a report with a large list of numbers that contain credits and debits. I sort the list and use my base list as a reference to differentiate what groups of numbers are debits and which ones are credits.
I am hoping there is an easier way to do this. My question is, is it possible to use the base list that I have as a template so that the next time I receive a report, I can just copy and paste the numbers onto the template and have them somehow formatted or programmed to reflect their correct code of either debit or credit?
I need to compare dates in excel (VBA programming). How can I do to Compare two dates. If I wanna know the difference between to dates (days, moths and years)
View 2 Replies View RelatedI have an excel sheet which has 5 columns & 5 rows.I would like to transpose values in 3rd column to 5th column .But after running my code I am not being able to get the deired output. rectify the error for me?
xlApp = CType(CreateObject("Excel.Application"), Excel.Application)
xlBook = CType(xlApp.Workbooks.Add, Excel.Workbook)
xlSheet = CType(xlBook.Worksheets(1), Excel.Worksheet)
xlSheet. Cells(1, 1) = "NAME"
xlSheet.Cells(1, 2) = "CITY"
xlSheet.Cells(1, 3) = "STATE
xlSheet.Cells(1, 4) = "ADDRESS"
xlSheet.Cells(1, 5) = "PINCODE"
Attached is my worksheet. I need to program column C to adjust the value in column A according to the rules set in table J2:K17, but ONLY if the value in column B = mens. If the value in B does not equal mens, then leave the C cell blank. I've manually populated column C to show the end result that I'm looking for.
I tried a simple =IF(ISNUMBER(SEARCH("Small",A2)),"S",""), etc., but I can't figure out how to incorporate the additional condition that would let the cell return a value ONLY when a condition in B is also met.
NBVC helped me with a similar request previously, but with that formula, if the condition wasn't met, the cell returned "#N/A" instead of being blank.
I been trying to create stuff that will make my work life real easy. I need creating a program that will send an email to different recipients. I created a spreadsheet the contains different information. When a persons name is selected on Column D, excel/outlook will generate an email to that person containing the info on Column A to D.
And then as soon as the work is processed and column G is filled, outlook will generate an email back to who created the requests column A.
I have some code below which looks at values added between a set range of cells. This works OK.
My problem is when i have to change the cell as it removes the background colour already set to certain columns ie Columns I, J, P, Q, W, X, AD, AE (these are coloured a light green).
The other cells in the range have no colour and so the code below works with no problem.
I'm trying to move my VBA programming to the next level and use more efficient code.
I'm wondering if there is a faster way to run the loop below, perhaps removing the 'For c = 2 to LastRow' as it seems a little clunky to me.
For c = 2 to LastRow
If Cells(c, Range("Product_Type").Column) = "" Then _
Cells(c, Range("Product_Type").Column).Interior.ColorIndex = 41
Next c
I've seen a similar thing somewhere where it was all done in one statement without the loop.
I'm building a macro thats copying 4 rows of data at a time from a spreadsheet (has 1500 rows of data total) and transposing it to a master spread sheet. There are blank rows in between each entry (the data source I'm using isn't clean), so how can I either have the macro jump to the first row it finds with a value, copy rows until it stops finding a value, paste+transpose into a new document and then repeat the process throughout the document.
If thats too complicated, a macro that finds rows based on a formula would work as well. E.g. Start at row 5, copy+paste+transpose 5-8, start at row 11 (5+6), copy + paste+transpose 11-14, start at row 17 (x+6) ...etc... Here's the code I have developed thus far:
I'm trying to set up a way to format column widths and row heights in a macro (so that it can read a value from a cell and format a column to that width). I've used the code below which can be repeated for the number of rows and columns desired below
Worksheets("Sheet1").Range("d1").ColumnWidth = Range("d1")
However, I want to be able to do this on a workbook that could potentially have 40+ sheets. Is there a way of applying this code to operate over the whole workbook rather than just one sheet at a time?
