$$Excel-Macros$$ Need Help With VBA using VLookup

2014-02-21 Thread Erick C
Good morning VBA masters. Let me start off by saying I am not a VB expert by any means. I am getting a bit better with modifying small things here and there, but I am absolutely lost when it comes to writing code from scratch. That being said, I have a code that works fine, but I am trying

$$Excel-Macros$$ Need help with code to automate copy/paste

2012-04-16 Thread Erick C
Hi everybody! I am hoping someone may be able to jelp me out. I am trying to write a macro that will take a formula that i write and copy it, move to the right seven spaces, paste, move seven spaces again, paste, ect.. Right now I need to have the formula pasted all of the way through column

Re: $$Excel-Macros$$ Need help with code to automate copy/paste

2012-04-16 Thread Erick C
Hi Ashish, Thank you, your suggestion works perfectly! Thanls again for the prompt response! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

$$Excel-Macros$$ Need VBA for repeating copy and paste special

2012-03-08 Thread Erick C
Hi everybody - I am hoping someone may be able to help me out. I am still quite a novice with writing VBA, so I am sure there is an easy way to make what I am trying to do. I am working in Excel 2010. I have a spreadsheet with a tab that has data vertically from column A through column ZW. I am

Re: $$Excel-Macros$$ Need VBA for repeating copy and paste special

2012-03-08 Thread Erick C
).End(xlUp).Offset(1).PasteSpecial Paste:=xlValues, Transpose:=True Next End Sub HTH Mahesh On Thu, Mar 8, 2012 at 8:54 PM, Erick C boricua2...@gmail.com wrote: Hi everybody - I am hoping someone may be able to help me out.  I am still quite a novice with writing VBA, so I am sure

$$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread Erick C
Hello everybody, I am in desperate need of some assistance, and I am hoping someone may be able to give me a hand. I am still a bit of a novice when it comes to vba code writing, so I am hoping that it may just be something that I am not aware of. I have some code that makes a string of text

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

2011-01-07 Thread Erick C
to pad with spaces. In VBA, your solution would be: StrOut = StrOut StrDelim _ Cells(R, 33).Value _ Application.WorksheetFunction.Rept( , 6 - Len(Cells(R, 33).Value)) Paul From: Erick C boricua2...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros

$$Excel-Macros$$ Need help with text alignment in VBA string

2011-01-04 Thread Erick C
I am hoping someone can help me out with a problem that I am having. I have a macro that I am working on in Excel 2003 right now that takes multiple fields from a spreadsheet and makes a text string. It was working great, until I had to add a few fields that were deemed necessary to have. I have

Re: $$Excel-Macros$$ Excel Macro - Need help using Find and Selecting a range

2010-10-01 Thread Erick C
From: Erick C boricua2...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thu, September 30, 2010 12:10:35 PM Subject: $$Excel-Macros$$ Excel Macro - Need help using Find and Selecting a range Hi everybody - I am hoping someone can help me out

$$Excel-Macros$$ Excel Macro - Need help using Find and Selecting a range

2010-09-30 Thread Erick C
Hi everybody - I am hoping someone can help me out with a problem I am having. I am very new to writing and recording macros, I have been trying to look at other macros that I use for different functions and tips. I have a macro that I am trying to get to do a few different things. The macro

$$Excel-Macros$$ Macro help - resize a column that is part of pivot table

2010-08-13 Thread Erick C
Hi everybody - I am hoping someone can help me out with a problem that I am having. I am trying to edit a macro, but I do not have a lot of experience writing macros and I cannot figure out the issue. I have a spreadsheet with a macro that does some formatting and refreshes a pivot table in a

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-25 Thread Erick C
) Then is comparing columns BM and AE. you probably  should have modified that part. As I said, try the debugger and step through to see what it is doing. You should find the problem then. sorry for the confusion (and sarcasm) ;) Paul From: Erick C boricua2

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-21 Thread Erick C
    '-- End Sub Paul From: Erick C boricua2...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thu, May 20, 2010 11:35:21 AM Subject: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

$$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-20 Thread Erick C
Good morning everybody - I am still quite a novice when it comes to VB and writing codes, so any help I can get would be greatly appreciated. I am currently working on a code that takes data from a xls file that I download and convert it to a text file. I found an older posting with an example

$$Excel-Macros$$ Can macro be made to automate Text-To-Columns?

2010-01-09 Thread Erick C
Hello everybody- I have a problem that I am hoping someone may be able to help me out with. I have some system-generated reports that I would like to use in Excel, but they are formatted for PDF viewing. Currently, I go in and use Text-To-Columns to split up the columns, but this is a bit