Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 09-13-2017, 02:32 AM
ewso ewso is offline recording ranges in macros Windows 10 recording ranges in macros Office 2016
Advanced Beginner
recording ranges in macros
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default

Thanks guys for the advice...let me give an example of what I want to do...

I want to be able to select a group of cells and in every other cell, I want to delete the contents. So if I have something like this...

A1...5
A2...3
A3...2
A4...6

I want to run the macro and have it look like this...

A1...5
A2...(blank)
A3...2
A4...(blank)

..The problem is I want the macro to apply to whatever I have selected at the time and not to those same cells every time. Can I just delete all the cell references in the macro and replace it with something like "SetRange Selection"?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
recording ranges in macros Recording Macros in Word doingwork Word VBA 1 10-10-2015 12:54 AM
recording ranges in macros Problems with Recording Macros jekronenfeld Excel 6 09-26-2013 03:07 PM
recording ranges in macros Recording Macros in Word cameron.fairfull Word VBA 2 09-08-2011 08:24 AM
Recording Macros Tutorial? Madhouse Word VBA 1 04-28-2010 01:32 PM
Tutorial recording macros Jaffa Word VBA 0 04-27-2010 09:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft