Dim Values As Range Dim CurrentSheet As Worksheet Set CurrentSheet = ActiveWorkbook.ActiveSheet Set Values = Rows(5) For j = 0 To 20 For i = 1 To Values.Cells.Count - 1 Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _ Formula1:="=Delimit2!$A$" & i, Formula2:="=Delimit2!$B$" & i Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Font Color = -16383844 TintAndShade = 0 End With With Selection.FormatConditions(1).Interior PatternColorIndex = xlAutomatic Color = 13551615 intAndShade = 0 End With Next i Next j In this I code, I would like to increment column A to C and B to D after For loop of i gets over.

Member Avatar
+0 forum 0

I have 2 sheets in same Excel. First excel sheet contains the following fields No Material 10th july 11th july 1 DATUM DCP ESD Black 2 DATUM DCP ESD Blue My second worksheet contains the following fields No Date Material Stock size+Wastage 1 10th july DATUM DCP ESD Black 283.47 2 10th july DATUM DCP ESD Black 661.6 3 11th july DATUM DCP ESD Blue 665.6 4 11th july DATUM DCP ESD Black 50.8 I want the following Expected result in the first worksheet:- No Material 10th july 11th july 1 DATUM DCP ESD Black 945.07 50.8 2 DATUM DCP …

Member Avatar
Member Avatar
+0 forum 1

Hi, I need to write a macro that has one row of dates. Row D. I need the macro to go down row and depending on the date I need to input a number to the cell to the right of that date. Example. If date < 12/22/16 insert value 0 if date >12/22/16 but < 12/31/16 insert value 1..... and so on. I am not sure much about code so please help me out thank you so much!

Member Avatar
Member Avatar
+0 forum 2

hi, I have an excel sheet and the is a row filled with data the row starts from B5 everytime, what i want to do it to read the values of the cell until the row comes to an empty cell how do i do it, thanks appreciate a reply, thanks

Member Avatar
Member Avatar
+0 forum 13

Hey Everybody. I have been asked to create a spreadsheet that will create a list of matches, for example in Table 1. (Please see the tables attached). OK, fair enough, basic table so far. What I want to do is have three columns, that will return the results that match the criteria given. So say for example I have the following values in Table 2 This would return a list of results detailing that Result 1 and Result 2 as having "x's" in those columns. Can this be done? If so, can you pleae point me in the right direction. …

Member Avatar
Member Avatar
+0 forum 3

Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into the original workbook (where the macro's originate) and then closes the existing file. After the copy and paste is done, this original worksheet (for some unknown reason) is being saved as a new file (that name is "89.123456"). For the life of me, I can't figure out why. Here's the code that runs this: Option Explicit Dim strategyName As String Dim docName As String Dim priceOptName As String Dim folderName …

Member Avatar
Member Avatar
+0 forum 5

Hi Group, I've written a macro to save a copy of the spreadsheet at the end of each day. I tried to test it as a shared file and learned the macro wouldn't work. Is this normal for a shared document? If so, is there a way around this? How can I do this? In advance, thanks for your help. Don

Member Avatar
Member Avatar
+0 forum 7

Think that macro viruses written in VBA (Visual Basic for Applications) are just something that people using the Internet a couple of decades ago had to worry about? Think again. Word macro attacks never went away, they just went into decline. New evidence suggests they could be making something of a comeback though. Coupled with research showing how non-English speaking recipients are being targeted by phishers using this technique, it makes for worrying reading some 15 years after [Melissa](http://en.wikipedia.org/wiki/Melissa_%28computer_virus%29) struck fear into the email using world. Whenever I hear non-English and phishing uttered in the same breath, I tend to …

Member Avatar
Member Avatar
+1 forum 2

**note:** This was also posted to the [comp.lang.scheme](https://groups.google.com/forum/#!forum/comp.lang.scheme) earlier today. I normally wouldn't cross-post, but after I noticed the extremely low traffic on the newsgroup, I decided to try a more active, if less specialized, forum. As part of a larger project, I am writing a macro that defines a variable and binds it to a list of pairs, where most of the pairs map a pattern and a value. Each pattern is a list, which may have a combination of symbols and strings. I am something of a novice with (define-syntax), and have struggled to get this to where …

Member Avatar
Member Avatar
+0 forum 4

Hi, I have a set of word macros which I need to share it with my friends. I want to make the job easy for them such that I share them an installable which they will install and all my macros will be automatically added in their PC's MS word s/w (If possible in the MS word ribbon as a shortcut). Is this possible? If yes, please let me know. Thanks Bala

Member Avatar
Member Avatar
+0 forum 6

I want to put the path and name of a spreadsheet, the page and number of pages and the date and time into the footer(s) and display it in Times New Roman 6 pts. I made the following macro: Range("A1").Select ActiveWindow.View = xlPageLayoutView` Application.PrintCommunication = False With ActiveSheet.PageSetup .LeftFooter = _ "&""Times New Roman,Standaard""&6 &Z&F" .CenterFooter = _ "&""Times New Roman,Standaard""&6 Page &P of &N" .RightFooter = _ "&""Times New Roman,Standaard""&6 &D &T" End With Application.PrintCommunication = True ActiveWindow.View = xlNormalView Range("A1").Select When I start the macro only a part of the centerfooter is filled. When I start the same …

Member Avatar
Member Avatar
+0 forum 3

I need to search the content from one list (List A, Column A) for the mention of items from another list (List B, Column A), and if any matches are found, I need to publish in Column B of List A the data from Column B of the associated matching item of List B. Can anyone help? Tables below to help clarify what I'm asking. **List A **(The list being searched) Column A Column B (blank) The bucket e(5) was full The broom stood The call came d(4) **List B** (The reference list - e.g., "does list A contain any …

Member Avatar
Member Avatar
+0 forum 1

I am having an impossible time finding a solution for this. I need to combine cell contents in an unusual way (see below), based on if there is an "x" in column A. See below for the exact representation of what I need to do in a worksheet with 200,000 total cells of content. Is there any hope? Anyone who can help will be my personal hero for life, and you may save a life (mine!)! Current data format A B C D E x a l g b m h Title A c n i x d o j …

Member Avatar
Member Avatar
+0 forum 6

I copied a list into Excel and some of the list formatted into the neihgboring columns instead of lining up in the list. I need to get the items floating out in the columns back into the proper place in the list. I assume I need to somehow run a Macro to insert a row below each cell in columns B-ZZ that contain text, and then somehow copy/past the floating values to Column A in the appropriate new row. Is there a Macro that can help? See below for example of issue. A B C D .... ZZ item 1 …

Member Avatar
Member Avatar
+0 forum 5

How can i copy data from a named range in a different worksheet and paste it to another worksheet all done without activating both sheet. With all code just behind a form button If i try to use the statement **application.goto reference:="x"** where x is the named range but this activates the sheets if i try to use the statement **range("workbookname!x")** where x is the named range, i get an exception Anyone please?

Member Avatar
Member Avatar
+0 forum 8

currently I have a class function: class MyClass{ static int E(int A,int B, int C){ //function code } }; //and I call it like this : MyClass::E(1,2,3); //what I would like to do is call it in this way: E(1,2,3); //my current macro definition is this #define E(a,b,c) Myclass::E((a),(b),(c)) how do I correct my macro definition to generate the corect code?

Member Avatar
Member Avatar
+0 forum 1

Does anyone how to hide excel macro worksheet each time excel 2007 starts up? using vba syntax thx

Member Avatar
+0 forum 0

Hello, I want to re-arrange my existing macros in the excel file. I have a macro which goes to the specified sheet and checks column R if there are commas. If it finds the commas it replaces it to dots. Column R is called Email. But in some of documents Email doesn't have to be in the R column - sometimes it's S sometimes in a different place. I have a second macro which does a similar job. The second macro finds the Email column itself (no matter where it was located) and deletes commas at the end of found …

Member Avatar
Member Avatar
+0 forum 12

Hello. I would like to ask for a help. I deal with excel spread sheets and very often I need to amend specific column. The whole steps look like this: Step 1. Find the column name, Step 2. Mark the all populated rows in this column, Step 3. Proceed with certain action (action means mostly find and replace or if other column is “this” then amend my column for “that) I would like to have a macro template which would have those first 2 steps specified and leave me the space to amend the code easily for proceeding with step …

Member Avatar
+0 forum 0

hi, I have a sheet name 'rate' and another sheet name "master". rate sheet has data as below EmpCol1 rateCol1 a 1 b 2 c 3 etc... and master has data as empCol2 rateCol2 c a b What i want to do is to get the rateCol1 from rate sheet and display infrom of the correct empCol2 . how do i go this? do i have to write an lookup? thanks

Member Avatar
Member Avatar
+0 forum 8

Can anyone recommend any software that will allow me to have *program-specific* key mappings? I have a problem with a laptop that has an odd keyboard map (in particular, the Enter and NumEnter have the same scancode)[1] and I need to be able to map another key combo to use something like Shift-Enter to generate another keycode. [1] It's a Samsung. I've asked them why it's like this; no-one can find an answer. What's particularly galling is that there's no reason to do this- software that *doesn't* care (most of it) will accept Enter or NumEnter indistinguishably- software that *does* …

Member Avatar
Member Avatar
+0 forum 1

When we define a variable name using #define in macro like: #define BUFFER_SIZE buff 5, and then in our main function declare a variable which has the same name like: int buff=8, Does the second buff overwrite the first one? I mean generally is a macro definition considered related to a non macro definition in main or are they totally separate?

Member Avatar
Member Avatar
+0 forum 9

My understanding of the C language is that the same identifier cannot be reused. However, the code below compiles on GCC without complaints, even when using the "-Wall -pedantic" flags. Is there something that I am missing? Does the standard say anything about functions/macros having the same name as typedef'd types? #include <stdio.h> typedef int error; #define init() error var_error = -6 #define error() ((const error)var_error) int main(void) { init(); printf("error() = %d\n", error()); return 0; }

Member Avatar
Member Avatar
+0 forum 2

Am having this piece of COde, but whenever am trying to execute this , Dim tsf As TestSetFactory - > error user not defined appears. pls help Dim tdc As TDConnection Sub UpdateStats() 'create QC connection QCconnect_silent "URL", "DOMAIN", "PROJECT", "USERNAME", "PASSWORD" 'process tests getMetrics 'disconnect QCdisconnect End Sub Private Sub QCconnect_silent(url As String, domain As String, project As String, user As String, pass As String) '# Creates a connection to QC On Error GoTo connected 'create the connection object Set tdc = CreateObject("TDApiOle80.TDConnection") tdc.InitConnectionEx url 'login to QC tdc.Login user, pass 'connect to project tdc.Connect domain, project Application.StatusBar = …

Member Avatar
+0 forum 0

Helloooo Firstly, ive done a bit of googling, and found a few articles relating to my problem. None seem to help though. I require a simple method of acquiring the "Page Number" of the selected cell. range1.Information(wdActiveEndPageNumber) Something like this, does not work. Even though i read that it does. I do not have any Vertical Page Breaks. They are all horizontal. The worksheet i will be viewing has about 30-40 pages. Are there any simple ways of doing this. NOTE: I DO NOT want a solution involving Print Preview. Regards Gobble

Member Avatar
Member Avatar
+0 forum 1

hi , i have a textbox control in one sheet and a range of data in another sheet in the same file. how do i copy the range of data in paste it in the textbox control? appreciate a reply thanks

Member Avatar
Member Avatar
+0 forum 12

I was wondering if there is any way using the mingw g++ compiler to make code that acts like this: [CODE]#define myLanguageBlock(X) doMyLanguageBlock(#X) void doMyLanguageBlock(const char* code){/*this executes the code as if it were in another language, I have already written this function*/} int main() { myLanguageBlock( this is all code written in my language. It has comma's, periods, and {brackets)][); return 0; }[/CODE] I am having trouble figuring this one out.

Member Avatar
Member Avatar
+0 forum 15

Hi. I'm sure this question has been asked before, but I can't get the text searched for. If anyone can explain them, refer me to an article, or give me the correct search query I would appreciate it. Thanks.

Member Avatar
Member Avatar
+0 forum 4

hi, i'm using winwedge to link up a balance to a computer, in order to gather the readings into an excel sheet. i've writen the code that starts winwedge at the press of a button, and created the macro that is supposed to request readings and send them to the excel sheet. Winwedge is configured to request excel to run the macro whenever a reading is sent. When i initiate winwedge and send data from the balance, it is displayed by winwedge but excel gives an error saying the macro is unavailable or disabled. If i run the macro manually …

Member Avatar
+0 forum 0

Hi everyone, I am totally new to VB and am trying to put together a macro. In short, I want it to select a range, store the values as an array (employee names). Then I want to loop through the values in the array. For each iteration, I want to go into a different sheet, filter it by each array value (each employee name), count the numbers of rows that show up in the filter result (represents holidays taken to date), make another array containing these values and then print this new array in the column beside the range where …

Member Avatar
Member Avatar
+0 forum 1

The End.