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
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
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
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
).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
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
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
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
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
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
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
)
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
'--
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
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
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
15 matches
Mail list logo